Microsoft Excel formula for calculating stamp duty in New South Wales (NSW), Australia.

excelStampDutyNewSouthWalesAustralia

=ROUND(
  IF(A1 > 3000000 , 150490 + 0.07   * (A1 - 3000000),
  IF(A1 > 1000000 ,  40490 + 0.055  * (A1 - 1000000),
  IF(A1 > 300000  ,  8990  + 0.045  * (A1 - 300000),
  IF(A1 > 80000   ,  1290  + 0.035  * (A1 - 80000),
  IF(A1 > 30000   ,   415  + 0.0175 * (A1 - 30000),
  IF(A1 > 14000   ,   175  + 0.015  * (A1 - 14000),
                             0.0125 *  A1))))))
,)

Thanks for this formula. Just what I needed.

Here are the updated vales from July 1 2022

=ROUND(
  IF(C4 > 3268000, 163940 + 0.07   * (C4 - 3268000),
  IF(C4 > 1089000,  44095 + 0.055  * (C4 - 1089000),
  IF(C4 > 327000,   9805  + 0.045  * (C4 - 327000),
  IF(C4 > 87000,    1405  + 0.035  * (C4 - 87000),
  IF(C4 > 32000,     442  + 0.0175 * (C4 - 32000),
  IF(C4 > 15000,     187  + 0.015  * (C4 - 14000),
                            0.0125 * C4))))))
,)

Reference source: https://www.revenue.nsw.gov.au/taxes-duties-levies-royalties/transfer-duty

updated based on July 2023 for anyone interested

https://gist.github.com/ljgoe/2bde9e7036c015dcbe3929a7e1bdd58f

=ROUND(
IF(D6 > 1400000, 163940 + 0.07 * (D6 - 3268000),
IF(D6 > 1168000, 47295 + 0.055 * (D6 - 1168000),
IF(D6 > 351000, 10530 + 0.045 * (D6 - 351000),
IF(D6 > 93000, 1500 + 0.035 * (D6 - 93000),
IF(D6 > 35000, 485 + 0.0175 * (D6 - 35000),
IF(D6 > 15000, 200 + 0.015 * (D6 - 14000),
0.0125 * D6)))))),)