If combined with OR & AND
Hi,
Every AND needs an Open parenthyses and a close parenthyses, and needs to be
treated as a single condition, an example below:
IF(AND(A1=2,B1=3),"YES","NO")
You put all your closing parenthyses at the end of the formula, close your
AND's and you should be ok.
HTH
Jean-Guy
"Micki" wrote:
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.
|