Using IF AND formular to display a cell with "0" as Yes. But it also returns empty cell

[cceze]

I wrote an IF AND formular to display "Yes" for a cell with zero. but when the cell is also empty, it still returns a "Yes" instead of empty.

any ideas how I can solve this please

this is the formular:
=IF(J2=3,"Yes",IF(AND(E2="",I2=0),"Yes","No"))

when I2 = 0 it returns Yes
Also with I2 = "", it still returns "Yes" instead of "No"

[minnesotaart]

In your example, what is the value of J2 when I2=""?

[cceze]

Oh Okay. i thought I followed the rules when sending

[abousetta]

Add a check to see if the cell is empty

Please Login or Register  to view this content.

abousetta

[cceze]

The value of J2 is still 3. the only cell that changed or changes is the I2

[cceze]

Perfect!!! Thanks Alot. I've been going crazy

[abousetta]

Excel sometimes has quirks that just need some tweaking.