Excel Nested IF's for Excel

Question

Thanks in advance, I am doing something dumb that I'm just not seeing.

=IF(ISNUMBER(L36),  IF( L36 < K3, "PASS", "FAIL"), "PASS", "N/A")

why doesn't his work?

Answer 1

Your first IF statement has four arguments (one too many!). You probably just want to remove the last "PASS" argument?

=IF(ISNUMBER(L36),IF(L36<K3,"PASS","FAIL"),"N/A")