1

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

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
Type: Question • Score: 1 • Views: 1,183 • Replies: 1
No top replies

2
Wed 6 Feb, 2013 07:43 am
@investor,
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.

Kevin
0 Replies

### Related Topics

1. Forums
2. » What is the easiest way to specify tax brackets in Excel?