Skip to content

Instantly share code, notes, and snippets.

@loanburger

loanburger/gist:92dcfc642eb3c66e6301cb90fdfc6530

Forked from danielcompton/gist:6724333
Created May 16, 2021 05:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save loanburger/92dcfc642eb3c66e6301cb90fdfc6530 to your computer and use it in GitHub Desktop.
Save loanburger/92dcfc642eb3c66e6301cb90fdfc6530 to your computer and use it in GitHub Desktop.
Download ZIP
Excel formula for calculating NZ tax paid on annual income.
Raw
gistfile1.txt
=IF(B2<=14000,SUM(B2*10.5%),IF(B2<=48000,SUM(B2-14000)*17.5%+1470,IF(B2<=70000,SUM(B2-48000)*30%+7420,IF(B2>=70001,SUM(B2-70000)*33%+14020))))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment