Scaled bonus help

Originally Posted by MarvinP

Did you expect them to get a bonus if they sold less than .50 of Goal? That is why it goes to ZERO for the bonus.

Use a few example numbers to see if your formula is correct. Do you want to calculate the BONUS or final pay?

I want it to calculate the final payout. The 330 * % to goal * accelerator. I just noticed that the VLOOKUP is only working if the % to goal is exactly matched with one in the reference table. It isn't taking into consideration that someone may be at 51% and multiply by .2.

Originally Posted by icestationzbra

what do you mean by "scale if under 50%"?

until then, here's another approach:

It doesn't seem to be multiplying by 0 if the % to goal is under 50%.

EDIT: Ice, your's works perfectly! Thank you!