Use AND() instead.

Look at this logic and see if it's what you're looking for:

B11 B11<"OFF" B11<"PTO" OR AND
OFF FALSE TRUE TRUE FALSE
PTO TRUE FALSE TRUE FALSE
ABC TRUE TRUE TRUE TRUE



In article ,
Kevin wrote:

=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.