[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Excel IF Statement

Posted on 2011-03-11
7
Medium Priority
?
229 Views
Last Modified: 2012-06-27
I am new at IF statements.  I have a date in one cell (C2), example 5/20/2011.  I want my IF statement to read, IF C2 is less than today's date return text of Past, IF C2 is greater than today's date return text of Present.

Ulimately I have 1011 rows of data & I need to quickly be able to see which are past appointments and which are future appointments.
0
Comment
Question by:mltardif
7 Comments
 
LVL 2

Expert Comment

by:jimponder
ID: 35112013
=IF(C2<(TODAY()),"PAST","")
0
 
LVL 24

Accepted Solution

by:
jimyX earned 200 total points
ID: 35112015
In C3 put:
=IF(C2>=TODAY(),"present","past")

And copy down.
0
 
LVL 2

Expert Comment

by:nidash
ID: 35112027
the formula would be cell d1 and would look like

=IF(C1<TODAY(),"PAST","PRESENT")

then copy across the formulas to all rows, finally manage visibility using autofilter where you can choose 'PAST'or "PRESENT'to look at what you want quickly.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Closing Comment

by:mltardif
ID: 35112039
Thanks so much!!!
0
 
LVL 2

Expert Comment

by:jimponder
ID: 35112056
I get in first and don't get credit... nice.
0
 

Author Comment

by:mltardif
ID: 35112074
Sorry but yours was a little confusing, the other one was idiot proof.
0
 

Author Comment

by:mltardif
ID: 35112083
And this person thought to add > = which I never even thought of.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

830 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