Stamp Duty Formula URGENT

[drmj00]

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:
[TABLE="class: table-border-stripes"]
<tbody>[TR="class: jquery-once-3-processed even"]
[TD]$0 - $14,000[/TD]
[TD]$1.25 for every $100 or part of the value[/TD]
[/TR]
[TR="class: jquery-once-2-processed odd"]
[TD]$14,001 - $30,000[/TD]
[TD]$175 plus $1.50 for every $100, that the value exceeds $14,000[/TD]
[/TR]
[TR="class: jquery-once-3-processed even"]
[TD]$30,001 - $80,000[/TD]
[TD]$415 plus $1.75 for every $100, that the value exceeds $30,000[/TD]
[/TR]
[TR="class: jquery-once-2-processed odd"]
[TD]$80,001 - $300,000[/TD]
[TD]$1,290 plus $3.50 for every $100, that the value exceeds $80,000
[/TD]
[/TR]
[TR="class: jquery-once-3-processed even"]
[TD]$300,001 - $1m[/TD]
[TD]$8,990 plus $4.50 for every $100, that the value exceeds $300,000[/TD]
[/TR]
[TR="class: jquery-once-2-processed odd"]
[TD]over $1m[/TD]
[TD]$40,490 plus $5.50 for every $100, that the value exceeds $1,000,000[/TD]
[/TR]
[TR="class: jquery-once-3-processed even"]
[TD]over $3m
[/TD]
[TD]$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.




[/TD]
[/TR]
</tbody>[/TABLE]

 

[etaf]

you can use a nested if

=IF( B3 >3000000, ((B3-3000000)/100 *7) + 150490 , IF( B3>1000000, ((B3-1000000)/100 * 5.5)+40490, IF( etc

But how do you manage the / $100
say the result of the difference is 210 do you round up to the nearest 100 - so its 3 or do you use 2 ?