combination or "if" and "or" formulas
=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.
|