Lewis255

Aug 21, 2024Copper Contributor

# Excel Formula help

Hi there, I need help with a formula to show the following – in first cell 12.5% commission when the gross total falls between (£30,001 – £50,000) In second cell 15% commission when the gross tot...

- Aug 21, 2024
First cell:

=MAX(MIN(A1, 50000)-30000, 0)*12.5%

Second cell:

=MAX(MIN(A1, 75000)-50000, 0)*15%