Andreamary
asked on
Replacing TRUE and FALSE with more meaningful text in date compare formula
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:
=($B2)/($D2)>1
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"
Thanks,
Andrea
=($B2)/($D2)>1
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"
Thanks,
Andrea
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
Andrea