Hi,
I'm having some problems with a nested Excel IF statement.
The statement is meant to show:
X if both C3 AND E3 are not 0.
Y if C3 OR E3 have a value that isn't 0.
Z if both C3 and E3 have values of 0.
This is what I have so far...
=IF((C3<>0)*AND(E3<>0),"X",IF(((C3<>0)*OR(E3<>0)),"Y","Z"))
Y is not being triggered
I'm using Excel 2013. Assistance would be greatly appreciated!
Bookmarks