Rufus 2006
Board Regular
- Joined
- Dec 15, 2005
- Messages
- 104
I have a simple formula that returns a "FALSE" answer don't meet the criteria. How can I get this to show a blank cell.
=IF($H59<>0,IF($H59<>9,IF($H59<>10,IF($H59<>20,IF(L61<6,1,"")))))
Thanks in advance for your help
Rufus
I am using Office for Mac 2011
=IF($H59<>0,IF($H59<>9,IF($H59<>10,IF($H59<>20,IF(L61<6,1,"")))))
Thanks in advance for your help
Rufus
I am using Office for Mac 2011