I have a spreadsheet in one column I have "date closed" on another I have "status".
I would like to write an if then formula to say, if a date is entered in F5 (date closed) then E5 says "Completed" (Status)
I have a spreadsheet in one column I have "date closed" on another I have "status".
I would like to write an if then formula to say, if a date is entered in F5 (date closed) then E5 says "Completed" (Status)
How about just a formula, like '=IF(ISBLANK(F5), "", "Completed")'?
It did not work for me.
f5 is an empty cell, when I type in a date I want E5 to say completed
Try:
=IF(F5="","","Completed")
SPARTAN
Please click the * if my solution helped
should the formula be in F5?
Because when I type the date the formula gets erased
Formula should be in E5, referring to the data in F5. When you enter a date in F5, this formula will show "Completed" in cell E5
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks