Programming a Transfer Duty Formula

[Kaleido]

Hey Guys

How do i program the following formula?

VALUE OF PROPERTY: TRANSFER COST

0-600 000 ______________0%
600 001 - 1 000 000 _____ 3% of value exceeding 600 000
1 000 001 - 1 500 000____ 12 000 plus 5% of value exceeding 1 000 000
1 500 001 and above_____ 37000 + 8% of value exceeding 1 500 000

I want to be able to type in the Property Value and get the transfer cost.

I do not have a cooking clue on how to do this???

Any help would be appreciated.

 

[oldbrewer]

you need a look up table similar to this

0 0 0 0
600001 600000 0 .03
1000001 1000000 12000 .05
1500001 1500000 37000 .08

lookup house price in the table and formula is (houseprice-vlookup(houseprice, mytable,2))*vlookup(houseprice,mytable,4) +vlookup(houseprice,mytable,3)

 

[Kaleido]

Thank you oldbrewer,

im going to try it now!