Solved

Replacing TRUE and FALSE with more meaningful text in date compare formula

Posted on 2014-03-16
2
189 Views
Last Modified: 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:

=($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
0
Comment
Question by:Andreamary
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 39932679
=if(($B2)/($D2)>1,"Update book","Book okay")
0
 

Author Closing Comment

by:Andreamary
ID: 39932688
Thanks for your quick response...works perfectly!

Andrea
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

As freelancing is becoming more and more common in the tech industry, certain obstacles are proving to be a challenge to those who are used to more traditional, structured employment. This article is meant to help identify such obstacles and offer a…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now