Perfect! Thank you.

"T. Valko" wrote:

Try this:

=IF(OR(A8={"New Hire","Attrition","Transfer"}),0,IF(Q8="",0,
IF(E8=--"1/31/2008",0,IF(AND(E8<--"1/31/2008",E8--"1/14/2007"),L8/12,
IF(AND(E8<--"1/15/2008",E8--"12/31/2007"),L8/24,"")))))


--
Biff
Microsoft Excel MVP


"Micki" wrote in message
...
I added something to my formula and now am getting a return of "FALSE". I
need the return to be zero or blank. Cell QW8 ias equal to " " when I get
the
FALSE return. I tried making it a zero instead of blank, and get the same
return.

=IF(OR(A8="New
Hire",A8="Attrition",A8="Transfer",0),IF(Q8="",0), IF(E8=--"1/31/2008",0,IF(AND(E8<--"1/31/2008",E8--"1/14/2007"),L8/12,IF(AND(E8<--"1/15/2008",E8--"12/31/2007"),L8/24))))

"Farhad" wrote:


--
Farhad Hodjat


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,"")))

i think this should be the correct syntax just put what you want instead
""
that i put in your if chains.

Thanks,
"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.