I can't seem to get this to work. Should be easy but I'm not getting the result I want
If $B18 is blank OR I enter a value of 0 in $E18 I want $G18 to be "No" otherwise $G18 will be the value that is in entered in $B18
Right now it works without out the layer of $E18. This works: =IF($B18="","No",$B18)
Adding the E18 test is just not working
The 0 seems to be hanging it up. $E18 can be blank or have a 0, or any number in it. I only want the No if B18 is completely blank or E18 has a 0 value. Since E18 can be blank I can't use a <1
Thank you in advance
If $B18 is blank OR I enter a value of 0 in $E18 I want $G18 to be "No" otherwise $G18 will be the value that is in entered in $B18
Right now it works without out the layer of $E18. This works: =IF($B18="","No",$B18)
Adding the E18 test is just not working
The 0 seems to be hanging it up. $E18 can be blank or have a 0, or any number in it. I only want the No if B18 is completely blank or E18 has a 0 value. Since E18 can be blank I can't use a <1
Thank you in advance