IFS to IF

[gusl91]

Hi - Excel newby making a first post here. I need to convert the following IFS function to an IF. I keep getting a message saying that I have too many arguments but can't work out why....

The original IFS:

=IFS(S$12<$J13, "a", S$12>$K13, "a", AND(S$12>=$O13, S$12>=$Q13), " ", AND(S$12>=$N13, S$12>$Q13), " ", AND(S$12>=$L13, S$12>=$Q13), " ", S$12>=$O13, "d", S$12>=$N13, "c", S$12>=$L13, "b", TRUE, "e")

My best guess at the IF:

=IF(S$12<$J13, "a", IF(S$12>$K13, "a", IF(AND(S$12>=$O13, S$12>=$Q13), " ", IF(AND(S$12>=$N13, S$12>$Q13), " ", IF(AND(S$12>=$L13, S$12>=$Q13), " ", IF(S$12>=$O13, "d", IF(S$12>=$N13, "c", IF(S$12>=$L13, "b", TRUE, "e"))))))))

[FDibbins]

Hi, welcome to the forum

Total guess but...
=IF(and(S$12<$J13, S$12>$K13), "a",if(AND(S$12>=$O13,S$12>=$N13, S$12>=$L13), " ", if(S$12>=$O13, "d", S$12>=$N13, "c", S$12>=$L13, "b", TRUE, "e")

or not. You have duplicate and conflicting tests in there
S$12<$J13,"a"
S$12>$K13, "a"
S$12>=$O13," "
S$12>=$N13," "
S$12>=$L13, " ",
S$12>=$O13, "d"
S$12>=$N13, "c"
S$12>=$L13, "b"

[gusl91]

Thanks for the reply!

Still the same 'too many arguments' response with that formula

I made the IFS function for some conditional formatting of a project plan - duplicates/conflicting tests don't seem to be an issue with IFS because only the first true value is taken, otherwise the formula works its way down to the final false..

[JeteMc]

Looking at the IF based formula in post #1 there are too many arguments to the very last If function ...IF(S$12>=$L13, "b", TRUE, "e")
S$12>=$L13 is the logical_test
"b" is the value_if_true
TRUE is the value_if_false
"e" is the argument that triggers the 'too may' error.
I am not sure what the intent of that part of the formula is, so I can't suggest a correction.
Perhaps if you tell us the logic of that particular part of the formula, we can figure out the syntax.

[BoredWorker]

Hope it help you,

=IF(S$12=TRUE,"e",IF(S$12>$Q13,"",IF(S$12>=$Q13,"",IF(OR(S$12>$J13,S$12<$K13),"a",IF(S$12>=L13,"b",IF(S$12>=$N13,"c",IF(S$12>=O13,"d","Nothing Match")))))))

it search from E > " " > A > B > C > D , and show Nothing Match if all compare is false.

[FDibbins]

Thanks for the reply!

Still the same 'too many arguments' response with that formula

I made the IFS function for some conditional formatting of a project plan - duplicates/conflicting tests don't seem to be an issue with IFS because only the first true value is taken, otherwise the formula works its way down to the final false..

That still doesnt resolve the conflicting rules there? All 3 "sets" of rules in my bolded section conflict