I am trying to create a formula for a tiered commissions calculator and have come up with the following:
=IF(C7<1000001,C7*0.02, IF(C7>1000001,C7*0.035,IF(C7>3000001,C7*0.04, IF(C7>5000001,C7*0.05))))
It doesn't seem to work properly, the calculation stops after the IF(C7>1000001,C7*0.035 IF STATEMENT and does not go on to use the rest of the formula.
Any assistance fixing this or creating a tiered commission calculation based on the 2% 3.5% 4% & 5% against the figures above would be great.
Thanks.
=IF(C7<1000001,C7*0.02, IF(C7>1000001,C7*0.035,IF(C7>3000001,C7*0.04, IF(C7>5000001,C7*0.05))))
It doesn't seem to work properly, the calculation stops after the IF(C7>1000001,C7*0.035 IF STATEMENT and does not go on to use the rest of the formula.
Any assistance fixing this or creating a tiered commission calculation based on the 2% 3.5% 4% & 5% against the figures above would be great.
Thanks.