tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
So i have a bit of a problem,
I need to work out an employees commission based on his sales,
we have up to 500 items at 10%
upto 1000 at 15%
over 1000 at 20%
so lets say in A7 is the number of sales 2000 for example, and in C7 is the amount sold for £25.00 So how can I do a formula that does this
first 500 at 10%
501 to 1000 at 15%
1001 up at 20%
= total commission
I have room for multiple cells if it easier?
thanks
Tony
So i have a bit of a problem,
I need to work out an employees commission based on his sales,
we have up to 500 items at 10%
upto 1000 at 15%
over 1000 at 20%
so lets say in A7 is the number of sales 2000 for example, and in C7 is the amount sold for £25.00 So how can I do a formula that does this
first 500 at 10%
501 to 1000 at 15%
1001 up at 20%
= total commission
I have room for multiple cells if it easier?
thanks
Tony