Calculation Question


S

Scott

I have to calculate total tax based on a graduated scale. Let's say I make
$15,000 (in cell A1) and I want to calculate tax in one cell (in cell B1).
The tax rate is such that the first $1,000 is at 0%, the next $2,000 at 10%,
the next $3,000 at 20%, and then anything higher than $6,000 at 25%.

What would the formula look like in cell B1 to calculate the tax expense of
$3,050.

Thanks,
Scott
 
Ad

Advertisements

M

Mike H

Scott,

Try this

=SUMPRODUCT(--(A1>{1000;3000;6000}), (A1-{1000;3000;6000}), {0.1;0.1;0.05})

Allin one line if it line wraps
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top