Forum Discussion

Kristie365's avatar
Kristie365
Copper Contributor
Dec 05, 2023
Solved

Excel Formula Error - Too Many Arguments - Comma or Parenthesis Error?

Greetings,   I am trying to create the following formula -  =IF(F2=$P$2,IF(M2>0.6,3%,IF(M2>0.5,2%,IF(M2>0.4,1%,IF(M2>0.3,0%)))),IF(F2=$P$4,IF(M2>0.6,3%,IF(M2>0.5,2%,IF(M2>0.4,1%,IF(M2>0.3,0%)))),I...
excel
  • Kristie365's avatar
    Kristie365
    Dec 05, 2023

    HansVogelaar This works! Thank you so much! And now makes much more sense. Have a wonderful day.

Patrick2788's avatar
Patrick2788
Silver Contributor
Dec 05, 2023

Kristie365 

I'm a bit late to the show but I'll offer SWITCH as an alternative to simplify things.

 

=LET(
    rates, {0, 0; 0.4, 0.01; 0.5, 0.02; 0.6, 0.03},
    SWITCH(F2, P3, 3%, P5, 1%, VLOOKUP(M2, rates, 2))
)

Resources