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?

CallumDA · Accepted Answer · 2017-03-13 17:03:06Z

6

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")

answered Mar 13, 2017 at 16:29

CallumDA

12.1k6 gold badges33 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1