mbishop2008
New Member
- Joined
- Nov 9, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Writing an if / then statement where I need 0 to display "0". I need 1 to display a certain field (F3) ,2 to display a certain field (F4) and 0 to display zero.
I had this formula and it works for 1 and 2, but 0 is coming back as the same as 1 because, well its less than 1. =IF(B6>2,$F$4)+IF(B6<2,F$3,F$4)
I had this formula and it works for 1 and 2, but 0 is coming back as the same as 1 because, well its less than 1. =IF(B6>2,$F$4)+IF(B6<2,F$3,F$4)