Skip to content

Instantly share code, notes, and snippets.

Microsoft Excel formula for calculating stamp duty in Tasmania (TAS), Australia. The output of this formula matches the official calculator (which rounds inputs to the nearest $100), but doesn't match the "letter of the law".
=
IF(A1 > 725000, 27810 + 0.045 * (CEILING(A1,100) - 725000),
IF(A1 > 375000, 12935 + 0.0425 * (CEILING(A1,100) - 375000),
IF(A1 > 200000, 5935 + 0.04 * (CEILING(A1,100) - 200000),
IF(A1 > 75000, 1560 + 0.035 * (CEILING(A1,100) - 75000),
IF(A1 > 25000, 435 + 0.0225 * (CEILING(A1,100) - 25000),
IF(A1 > 3000, 50 + 0.0175 * (CEILING(A1,100) - 3000),
50)
)))))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment