Skip to content

Instantly share code, notes, and snippets.

@pauldwhitman

pauldwhitman/excelStampDutyQueenslandAustralia-LongForm

Last active November 15, 2016 05:54
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save pauldwhitman/89b68e5d99ef2d698ff9b0165c2abecb to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save pauldwhitman/89b68e5d99ef2d698ff9b0165c2abecb to your computer and use it in GitHub Desktop.
Download ZIP
Microsoft Excel formula for calculating stamp duty in Queensland (QLD), Australia. Long form edition without any "magic numbers".
Raw
excelStampDutyQueenslandAustralia-LongForm
=ROUND(IF(A1>1000000,(75000-5000)*0.015+(540000-75000)*0.035+(1000000-540000)*0.045+0.0575*(A1-1000000),IF(A1>540000,(75000-5000)*0.015+(540000-75000)*0.035+0.045*(A1-540000),IF(A1>75000,(75000-5000)*0.015+0.035*(A1-75000),IF(A1>5000,0.015*(A1-5000),0)))),)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment