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. C...
- Sep 19, 2018
Hi John,
Change
F19=P on F19="P"
SergeiBaklan
Sep 19, 2018MVP
Hi John,
Change
F19=P on F19="P"
John Hendrickson
Sep 19, 2018Copper Contributor
Thanks, that worked!