I was putting number in enter cost over $50,000 or higher and I did manualy calculations the line where 7.5% is getting bigger when I put the bigger number in enter cost. It should stay the same when the cost is over $50,000.


I am trying to figure it out how to change it.

Thank you

I see an error on zyzzyva57's sheet in Cell B12 - the value in this formula can be greater than 30000*0.075 - the argument that you have stated is

If B10 is greater than 20,000, then take the figure in B10 and subtract 20,000 and multiply the remainder by 0.075

There is no upper limit though!, so if B10=60,000 then the sum becomes

=(60,000-20,000)*0.075

ie:

40,000 x 7.5%

Whereas, the maximum MUST be 30,000 x 7.5%

You could always embed IF Functions to make it one formula, rather than notations on the sheet!

=IF(B10>20000,(IF(B10>50000,((B10-50000)*0.05+B10+(20000*0.1)+(30000*0.075)),(B10-20000)*0.075+B10+(20000*0.1))),B10=(B10+(B10*0.1)) )

All you have to do is change the Reference Cell [B10] and, if needed, the Percentages [0.05, 0.075, 0.1] in the formula!

Can it be broken up into different cells like it shown on zyzzyva57's attachement?

Yup - all you need to do is alter zyzzyva57's formula in B12 to:

If you want the cells to show nothing in them if there is no value, then change the 0 at the end of the formula in B13 to "" as in the code above.
If you want the cells to show $0.00 in them if there is no value, then change the "" at the end of the formula above to 0.