combination or "if" and "or" formulas
Try reversing the logic:
=IF(OR(SCHEDULE!B11={"off","pto",""}),0,8)
Biff
"Kevin" wrote in message
...
=IF(OR(SCHEDULE!B11<"OFF",SCHEDULE!B11<"PTO"),"8 ","0")
Whats wrong with my formula? I would like it post an 8 when B11 on the
SCHEDULE workbook shows anything other than OFF or PTO, and a 0 otherwise.
It
works for the OFF, but not for the PTO.
Thanks.
|