pauldwhitman/excelStampDutyVictoriaAustralia-LongForm

Created November 13, 2016 08:50

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/pauldwhitman/a66bc4cf587e11e404b412d3ad8d2002.js"></script>
Save pauldwhitman/a66bc4cf587e11e404b412d3ad8d2002 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

excelStampDutyVictoriaAustralia-LongForm

=ROUND(IF(A1>960000,A1*0.055,IF(A1>130001,(0.014*25000)+(0.024*(130000-25000))+(0.06*(A1-130000)),IF(A1>25001,(0.014*25000)+(0.024*(A1-25000)),A1*0.014))),)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment