| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Threaded Mode
