Skip to content

Instantly share code, notes, and snippets.

@pauldwhitman
Last active January 29, 2017 05:52
Show Gist options
  • Select an option

  • Save pauldwhitman/dadbfc6dd0e95bbdc1dc24898789d708 to your computer and use it in GitHub Desktop.

Select an option

Save pauldwhitman/dadbfc6dd0e95bbdc1dc24898789d708 to your computer and use it in GitHub Desktop.
=
IF(A1 > 725000, 28453 + 0.0515 * (A1 - 725000),
IF(A1 > 360000, 11115 + 0.0475 * (A1 - 360000),
IF(A1 > 150000, 3135 + 0.038 * (A1 - 150000),
IF(A1 > 120000, 2280 + 0.0285 * (A1 - 120000),
0.019 * A1)
)))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment