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%
Hi,
Is your IF(AND) function something like this:
=IF(AND(A1>=30001,A1<=50000),12.5%,IF(AND(A1>=50001,A1<=75000),15%))
So if A1 contains 30003 you get a result of 12.5% and if it contains 50003 you get 15%.
Or are you looking to combine the result with a value and text, so that it needs CONCAT also?
Is your IF(AND) function something like this:
=IF(AND(A1>=30001,A1<=50000),12.5%,IF(AND(A1>=50001,A1<=75000),15%))
So if A1 contains 30003 you get a result of 12.5% and if it contains 50003 you get 15%.
Or are you looking to combine the result with a value and text, so that it needs CONCAT also?