Get instant live expert help on if function text
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Understand a if plus date function - if a cell has text then return a date
Solved by C. Q. in 28 mins
How do I create a function to replicate text in a cell if a preceding cell has text that is BOLD?
Solved by O. H. in 13 mins
Add a formula to cell G4 that creates a Report ID from the date and the ID number on the ListData worksheet of the person who made the report. The excel IF function TEXT will include a TEXT function and a nested IF function with a VLOOKUP function.
The logical test will verify if cell G2 is greater than 0.
The value if true will include the TEXT and VLOOKUP functions: TEXT(G2,"YYYYMMDD"),"")&" "&IF(G1>0,VLOOKUP(G1,ListData!B15:C19,2)
The value if false will return blank.
Solved by A. A. in 27 mins
In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, the text “Invalid Staff ID” should be displayed by the formula.
Solved by M. L. in 26 mins
I need to do an IF function with text in the box then it comes up as "Loc" and if not it comes up as "-".
i.e. the function should read =if(A1=SOMETHING, "Loc", "-") but I don't know what that "something" is
That "something" should recognise that there's text in the relevant area. It is typed text and not numbers in the relevant area.
It goes from row 171 to 899
Solved by O. J. in 11 mins