# 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%)))),IF(F2=$P$3,3%)),if(F2=P5,1%))

I keep returning too many arguments error - I've tried my best to adjust commas/parenthesis in a logical way to alleviate, but cannot figure it out!

If I remove the final portion of the formula, it returns the correct information and reads the formula correctly:

=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%)))),IF(F2=$P$3,3%)))

However, I need that final formula (IF(F2=P5,1%) added to make the formula usable for my workbook.

Please let me know if anyone knows what I'm missing or sees a resolution.

Thank you

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