Can't get percentage to change depending on the sum value

[cloud-pilot]

Hi
I don't know if there is a formula for this? but here's the problem

Let's say I want to give company staff a bonus based on the amount of sales they earn?

If they earn below £5000 of sales in a month, their bonus would be 5%, if they earn between £5000 - £10,000 of sales in a month then they would receive 10% and 15% for anything above, so need the percentage to change once the value reaches each threshold.

Thanks in advance

[Louie25]

Hi,

I'm not sure this is the simplest formula to solve your problem but try

=IF(A1<=5000,A1*5%,IF(A1<=10000,A1*10%,IF(A1>10000,A1*15%,0)))

Based on the sales number being in cell A1.

Less than or equal to 5000 is 5%
Less than or equal to 10000 is 10%

Anything more 15%

[MrShorty]

I would use a lookup table and a lookup function for something like this (vlookup() function help: https://support.office.com/en-us/art...rs=en-US&ad=US )