Thread: IF/AND/OR Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default IF/AND/OR Help

I think you've over complicated it


=IF(OR(F2<40,AND(DateTest,OR(L2=0,L2="",L2="TBD")) ),"X","")

I've put in DateTest rather than typing your formula again, but this
SHOULD do what you want!