Forum Discussion
John Hendrickson
Sep 19, 2018Copper Contributor
Excel nested IF statements
I have created the following nested IF statement:
=IF(L7=0," ",IF(G18=L9,"P",IF(AND(F19=P,L11=0),"H",IF(AND(F19=P,L11>0),"E"," "))))
There is something wrong with this as I get the #NAME? error.
Can anyone find the syntax error?
Is the problem because I am using both IF statements and IF(AND) statements together in the same string?
Thanks.
Hi John,
Change
F19=P on F19="P"
Hi John,
Change
F19=P on F19="P"
- John HendricksonCopper Contributor
Thanks, that worked!