wakerider017
Board Regular
- Joined
- Jun 10, 2015
- Messages
- 77
Out of curiosity, why does my formula with multiple does not equal signs "<>" not work while my formula with equal signs "=" does?
=IF(OR(I2="Closed Lost",I2="Closed Won",I2="Closed-RHB Declined",I2="Fall-Back",I2="On Hold"),"CLOSED","") Works
=IF(OR(I2<>"Closed Lost",I2<>"Closed Won",I2<>"Closed-RHB Declined",I2<>"Fall-Back",I2<>"On Hold"),"OPEN","") Does Not Work
=IF(OR(I2="Closed Lost",I2="Closed Won",I2="Closed-RHB Declined",I2="Fall-Back",I2="On Hold"),"CLOSED","") Works
=IF(OR(I2<>"Closed Lost",I2<>"Closed Won",I2<>"Closed-RHB Declined",I2<>"Fall-Back",I2<>"On Hold"),"OPEN","") Does Not Work