Nested if isblank, or, and excel function.

[larryt1940]

I have an =IF(ISBLANK statement below that works.

What I need to add to it are two additional tests:

Test 1: if N2 ISBLANK AND Q2 is equal to or greater than zero, the formula needs to return "100%"

Test 2: if N2 and Q2 ISBLANK, the formula needs to return "Request Info"

Current Formula:

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

Scenario 1
N2=ISBLANK
Q2=0
Return "100%"

Scenario 2
N2=ISBLANK
Q2=ISBLANK
Return "Request Info"

Note: the formula needs to be relative since it's used in an Excel Table.


Many thanks for your help.