Hello All,

Just after a bit of help as I cant get my head round how to set this up.

I want to create a table showing take home pay from commission earnt

The difficulty being the commission percentage isn't flat, from 0 to 15000 the sales person earns 5%, from 15001 to £35000 the sales person earns 10% and anything above this the sales person earns £20%.

For example,

comms of 45,000
0-15000 5% = ?750
15001- 35000 10% = ?2000
35001-45000= 20% 2000
Total take home 4750

Any ideas how to set this table up?

Thanks in advance