Hi guys, im just making a simple spread sheet and need to work out a formula for NSW stamp duty: on sheet 1 i have the house value in cell B3, and on sheet 2 i have the stamp duty amounts so i can have them separate/not visible from sheet 1:
<tbody>
</tbody>
$0 - $14,000 | $1.25 for every $100 or part of the value |
$14,001 - $30,000 | $175 plus $1.50 for every $100, that the value exceeds $14,000 |
$30,001 - $80,000 | $415 plus $1.75 for every $100, that the value exceeds $30,000 |
$80,001 - $300,000 | $1,290 plus $3.50 for every $100, that the value exceeds $80,000 |
$300,001 - $1m | $8,990 plus $4.50 for every $100, that the value exceeds $300,000 |
over $1m | $40,490 plus $5.50 for every $100, that the value exceeds $1,000,000 |
over $3m | $150,490 plus $7.00 for every $100, that the value exceeds $3,000,000 In Sheet 1 cell B6 is where i want the amount to appear of the stamp duty amount according to the land value in cell B3 Please help me with this formula, cant work it out. |
<tbody>
</tbody>