Error message in my excel formula
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".
You can always break up your formula in a text editor like I've done below.
There you see outermost IF
has 5 parameters.
IF(
N3=0,
"N/A",
IF(
Q3=0,
IF(
M3<=N3,
"FAIL",
"PASS"
)
),
IF(
M3>=O3,
”PASS”,
”FAIL”
),
0
)