Forum Discussion
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...
HansVogelaar This works! Thank you so much! And now makes much more sense. Have a wonderful day.
Try this:
=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=$P$5,1%,""))))
HansVogelaar This works! Thank you so much! And now makes much more sense. Have a wonderful day.