View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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.