Forum Discussion

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

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...
  • SergeiBaklan's avatar
    Sep 19, 2018

    Hi John,

     

    Change

    F19=P   on
    F19="P"

Resources