Solved

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

Posted on 2014-03-16
2
196 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Companies keep a much closer eye on costs today, so changing to new Technology – Microsoft Office 365 is the smartest move to take.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

732 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