Forum Discussion
Tiered Formula Calculation
I am having a hard time envisioning how to prepare a formula to calculate the net earnings for a tiered calculation. The revenue is 2.5% of the closed business. Then two separate sides split the 2.5%...
Weird. When I do the real math I believe I get a revenue stream of $107,500. I'm not sure what the delta is between your formula and my manual calculation.
=IF(D4>4000000,(D4-4000000)*0.7+2000000*0.6+2000000*0.5,
IF(AND(D4<=4000000,D4>2000000),(D4-2000000)*0.6+(2000000)*0.5,
IF(D4<=2000000,D4*0.5)))*0.025
Unfortunately i didn't understand what you want to do. Above formula is what you are looking for i suppose.