Forum Discussion
Solved
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...
First cell:
=MAX(MIN(A1, 50000)-30000, 0)*12.5%
Second cell:
=MAX(MIN(A1, 75000)-50000, 0)*15%
First cell:
=MAX(MIN(A1, 50000)-30000, 0)*12.5%
Second cell:
=MAX(MIN(A1, 75000)-50000, 0)*15%
Legend!!!
