Simple IF function Closed

Question

Hello, 

I have a column reading random dates (dd/mm/yy) and the column next to it has to read "Y" or "N" depending on whether the date is before or after 1st Aug 2013. So the cell next to the date should read "Y" if it is after the 1st Aug 2013, and should read "N" if it is before the 1st Aug 2013.

How would I write this IF function?

Cheers,
Lubna

Configuration: Windows 7 / Internet Explorer 9.0

ac3mark · Answer

Ok, I hope this helps.

The syntax for if is as follows: if(logic_test,true,false)

So this should do it:
=IF(TODAY()>A1,"Y","N")

A1 is the cell to check for the date.

Have FUN! 
 
"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon

rayh · Answer

Would this be closer to the requirement as the date is not based on TODAY's date but rather one that already exists in a column.

in cell B1:
=IF(A1>=DATE(2013,8,1),"Y","N")

This assumes Aug 1st should be Y, as this is unclear in the question

Simple IF function

2 responses

Similar discussions

Subscribe To Our Newsletter!