Formula assistance nested If's/or

[Rockerdo]

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

 

[frank_AL]

Using Functions IF along with OR will give you the desired result. With the OR Function, both items being evaluated are checked.

=IF(OR(ISBLANK(B18),E18=0),"No",B18)

 

[Rockerdo]

I knew it couldn't be as hard as I was making it. Thank you!