Nested if isblank, or, and excel function.

[Admin]

=IF(AND(ISBLANK(N2),ISBLANK(Q2)),"Request Info",IF(AND(ISBLANK(N2),Q2=0),"100%",1-((N2)/((P2)-(O2-Q2)))))

[larryt1940]

Hi Admin,

Thank you very much for your help.

I came up with the following code that is pretty close to your's. Is there any difference that you can see, other than dropping the "and" on the second condition and wrapping the code in the "iferror" statement?

=IFERROR(IF(AND(ISBLANK(N2),ISBLANK(Q2)),"Request Info",IF(AND(ISBLANK(N2),AND(Q2>=0)),"100.0%",1-((N2)/((P2)-(O2-Q2))))),"100.0%")

LarryT