Replacing TRUE and FALSE with more meaningful text in date compare formula
Posted on 2014-03-16
Column B and Column D contain date/time stamps. I am using this formula below to check whether the date in Column B is newer than the one in Column D, and Column E gives TRUE or FALSE results:
I would like a formula that replaces TRUE and FALSE results with more meaningful text as follows:
If FALSE, then "Book okay"
IF TRUE, then "Update book"