Reducing a series of calculations to one input and one result

I have a series of three calculations to determine the Property Tax, which varies dependent on property value.

Goal: To reduce the formulas to only one "Price" input cell and one "Total" result cell.

I have tried nested =IF formulas without success.

Please try

=SUMPRODUCT((B5>{0;2;20}*10^5)*(B5-{0;2;20}*10^5)*{1;1;1}%)

{0;2;20}*10^5 is your step 0 200k and 2m

{1;1;1}% is your increasing rate 1% and 1%+1% = 2% and 1%+1%+1% = 3 %

An elegant and simple solution (That is once I wrapped my head around it )
My =IF nested attempts went nowhere. Thank You!

I am following your formula, with the exception of the value -N near the end. Where did that come from?
=SUMPRODUCT((B5>D18:D20)*(B5-D18:D20)*(E18:E20-N(+E17:E19)))

I used your elegant second version.
=SUMPRODUCT((B5>{0;2;20}*10^5)*(B5-{0;2;20}*10^5)*{1;1;1}%)
It works quite well!

Thank you for your input
Bay

(E18:E20-N(+E17:E19)) ={1%;1%;1%}

N() change text to 0 , number still number.

E17 is Column header "Tax" or "Tax rate"

1%-"Tax" give error #Value! but 1%-n("Tax") = 1%-0 = 1%

Got it. Thanks.

Update on the solved problem by Bo_Ry

Re the new uploaded sheet "Reverse Calculation.xlsx

I wonder if it would be possible to place an amount in G7 and have a formula in G9 that would calculate The Negotiated Discount?
In other words for example, if $1,517,800.00 was placed in G7, then G9 would produce $10,000.00

Reverse calculating this with the Property Purchase Tax formula seems quite difficult.

Bay since your thread has been reopened it would be a good idea to change the Solved status to 'Mark this thread unsolved'. Otherwise it might not get noticed.

Dave
I was using my cell phone & the Excel Forum site did not contain any SOLVED or "Mark this thread unsolved" buttons. Back home with the PC and there they are. Did as you suggested. Tnx.