Excel Formulas and Functions: Tax

L

llenuts

Hi all, don't know if this is the right place to post this question, o
dont know if you will understand what i mean, might be very simple, bu
anyway, here goes.

I was trying to create a "Pay Calculator" and am having trouble wit
the Tax part formula(s). Tax is calculated on value of C10. Exampl
is, No tax under $110 made, $1 tax if I make between $110-115, $2 ta
if i make between $115-$120, $3 tax if i make between $120-$125 and s
on.

Just wondering if someone could help me with a solution her
hopefully.
Please contact me if anymore info is required?.

Thanks, Josh
llenuts at hotmail.co
 
N

Norman Harker

Hi Josh!

Try:
=INT((A1-110)/5)+1

Your boundaries are overlapping. The above gives tax of:
=110 <115 $1
=115 <120 $2
=120 <125 $3
Click to expand...
etc

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/
 
A

A.W.J. Ales

llenuts,

Try =MAX(INT(C10/5)-21,0)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
L

llenuts

Thanks all for your quick replies. All formulas appear to work for thi
problem so thankyou all. Given numbers were just an example but I hav
chosen the following and changed just one number to acquire desire
results: =MAX(INT(C10/5.25)-21,0)

Once again, thanks, Josh
 
A

A.W.J. Ales

YW Josh and thanks for your reaction.
it's always nice to hear that a suggestion works.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Top