If combined with OR & AND
Was hoping I wouldn't have to. Thanks.
"David Biddulph" wrote:
You are comparing with text strings, not with dates. For dates, use the
DATE() function.
--
David Biddulph
"Micki" wrote in message
...
Cell E14 contains a date and I want certain things to happen if the date
is
equal to certain criteria. I'm having problems with the syntax.
IF(E14="1/31/2008",0,if(AND(e14<"1/31/2008",e14"1/14/2007",L14/12,if(AND(e14<"1/15/2008",e14"12/31/2007",L14/24)))))
Thank you.
|