Excel : Transfer /Duty

[Dolby]

How would I make the following in Excel, assuming property price is cell A1 ?

Looks pretty complex and I've downloaded a bond calculator, but can't find an Excel template calculator

 

[L-Dog]

Set up an excel with formulas or just use this

Transfer and Bond Cost Calculator

Get the estimated transfer and bond registration costs using our calculator

www.nedbank.co.za

 

[Dairyfarmer]

Fairly easy one that. Give us a few

 

[swift412]

This should work:

=IFS(
   A1 > 11000000, 1026000 + ((A1 - 11000000) * 0.13),
   A1 >  2475000,   88250 + ((A1 -  2475000) * 0.11),
   A1 >  1925000,   44250 + ((A1 -  1925000) * 0.08),
   A1 >  1375000,   11250 + ((A1 -  1375000) * 0.06),
   A1 >  1000000,       0 + ((A1 -  1000000) * 0.03),
   TRUE, 0
)

 

[Dairyfarmer]

You can hide column K and lock all cells except I1. Exactly same code as @swift412 , but you can edit values in cells on the left (% and Rands)