I gave a formula like
IF(N3=0,"N/A",IF(Q3=0,IF(M3<=N3,"FAIL","PASS")),IF(M3>=O3,”PASS”,”FAIL”),0)
and its showing error message as "To many arguments for this function".
microsoft excelworksheet-function
I gave a formula like
IF(N3=0,"N/A",IF(Q3=0,IF(M3<=N3,"FAIL","PASS")),IF(M3>=O3,”PASS”,”FAIL”),0)
and its showing error message as "To many arguments for this function".
Best Answer
You can always break up your formula in a text editor like I've done below.
There you see outermost
IF
has 5 parameters.