Nesting IF Statements

[lyonstl03]

I'm trying to get a nested IF function to work, but it's saying I have too many arguments.
H I

=IFERROR(SUM(F46/E46), "N/A") ----- This is my Formula in H
=IF(H48<0.95, "FAIL", "PASS") ------ This is my Formula in I

Why does =IF(H48<0.95, "FAIL", "PASS",IF(H48="N/A", "N/A", "N/A")) not work?

Thanks!

 

[gaz_chops]

Try

=IF(H48="N/A", "N/A", IF(H48<0.95, "FAIL", "PASS"))

Or

= IF(H48<0.95, "FAIL",IF(H48="N/A", "N/A", "PASS"))

 

[lyonstl03]

Thanks you! That worked perfectly.

 

[gaz_chops]

You're welcome.

Yours would not work because the 1st IF statement ended here "=IF(H48<0.95, "FAIL", "PASS"here,IF(H48="N/A", "N/A", "N/A"))"
so the 2nd IF was giving the "Too many arguments" error.

 

[lyonstl03]

Similar =IF question -

=IF(AND(H3>0.9,M3>0.9),"PASS", "FAIL",IF(M3="N/A", "N/A", "")) - This is my feeble attempt.

If these cells are over 90% then they pass, but I have an =IFERROR function setup to return "N/A" if there is no document that needs a grade. How can I get the PASS or FAIL to have a third IF that if the cell equals "N/A" then the output is N/A?

 

[Fluff]

How about
=if(M3="N/A","N/A",if(and(H3>0.9,M3>0.9),"Pass","Fail"))

 

[lyonstl03]

I swear that I tried that same thing. That works perfectly and it actually helped be get exactly what I needed which was
=IF(AND(M2="N/A",H2="N/A"),"N/A",IF(AND(H2>0.9,M2>0.9),"Pass","Fail"))
I need both columns to show N/A for there be to no overall average.
Thanks again!

 

[Fluff]

Glad to help & thanks for the feedback.