What is the easiest way to specify tax brackets in Excel?

Reply Fri 11 Jan, 2013 04:39 pm
I'm trying to write a formula to estimate investment gains for several years and would like to subtract taxes each year. However, I am having trouble figuring out an easy way to specify different actions (subtracting different amounts) according to the various tax brackets.

For instance, I would like 10% subtracted when capital gains are between $0 and $12,750, and 15% subtracted when capital are between $12,750 and $48,600.

I'm familiar with the "=IF" command, however I am not sure about the easiest way to say "if value falls between 0 and 12750, do this; if it falls between 12750 and 48600, do that." In other words, my difficulty is not so much with the "=IF" thing (I don't think), but is more with setting up the different ranges of values (like between 12750 and 48600, for example). Something like a "BETWEEN" command would be ideal.

Anybody got any good ideas?
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 1 • Views: 1,183 • Replies: 1
No top replies

Reply Wed 6 Feb, 2013 07:43 am
Hi investor

See if this is of any help, using the LOOKUP function And assuming the value is in A1: =A1-(A1*LOOKUP(A1,{0,12750.01},{0.1,0.15}))

Better still would be a assumption table in your sheet and then using a VLOOKUP.

0 Replies

Related Topics

  1. Forums
  2. » What is the easiest way to specify tax brackets in Excel?
Copyright © 2019 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 10/19/2019 at 01:33:03