| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with simple if statement | Excel Worksheet Functions | |||
| Simple IF statement | Excel Worksheet Functions | |||
| Simple if statement? | Excel Programming | |||
| Simple If Statement | Excel Worksheet Functions | |||
| Simple IF statement | Excel Programming | |||
Threaded Mode
