Excel Formulas and Functions: Tax

  • Thread starter Thread starter llenuts
  • Start date Start date
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
 
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
(e-mail address removed)

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/
 
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 *
 
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
 
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 *
 
Back
Top