loanburger/gist:92dcfc642eb3c66e6301cb90fdfc6530

Forked from danielcompton/gist:6724333

Created May 16, 2021 05:01

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

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/loanburger/92dcfc642eb3c66e6301cb90fdfc6530.js"></script>
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