Answers: Use Excel assist for the IF statement. I forget exactly how to do it otherwise I'd be more specific but the string within the box will be something resembling:
If A1=''(Answer1,Answer2) where on earth '' is two ' and not a speech put pen to paper and Answer1 is if the condition is true, Answer2 if it is false.
You hold to put a formula surrounded by. =IF(A1="",one piece,other thing)
=IF(A1="", This finances that if cell A1 is blank
one entity put this if A1 is blank, if this is workbook consequently it wants to travel within quotation grades.("one thing")
other thing put this in if A1 is not blank (use quotes for text)
Use the following in any cell bar A1:
=IF(ISBLANK(A1), "Empty", A1)
This will any display what is within Cell1, but if Cell 1 is deserted, it will write Empty.
=IF(A1=" "," ","text")
so you would type that into cell A2, next if A1 be blank, A2 would also be blank, but if anything else be written contained by A1, the word essay would be displayed surrounded by A2