Forum Discussion

John Hendrickson's avatar
John Hendrickson
Copper Contributor
Sep 19, 2018

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.

Resources