Margin King
New Member
- Joined
- May 23, 2023
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hi there.
Can someone help me with a consistent formula to calculate commission based on an increasing scale eg commission on revenue is 6% for the first £30k, 8% for the next £10k and 10% from then on.
Ideally the same formula in all the monthly cells highlighted in yellow in the attached image without using loads of 'Sum' & 'If's
Thanks
Can someone help me with a consistent formula to calculate commission based on an increasing scale eg commission on revenue is 6% for the first £30k, 8% for the next £10k and 10% from then on.
Ideally the same formula in all the monthly cells highlighted in yellow in the attached image without using loads of 'Sum' & 'If's
Thanks