simple IF statement
Brilliant thank!!
"Roger Govier" wrote:
Hi
=IF(E3<--"03/03/07","this","that")
or
=IF(E3<DATE(2007,3,3),"this","that")
--
Regards
Roger Govier
"Gemz" wrote in message
...
Hi,
Please can you help on an IF statement.
I just need to know how i can say in an IF statement if cell E3 is <
03/03/07 then if true 'this' and not true 'that'. I have tried it like
this
but although it works it gives me inaccurate results, i think its not
recognising the date properly.
All i want to say is if the dates in column E are less than 03/03/07 (i.e.
dates before this period then etc etc).
How can i state this in my IF statement?
thanks.
|