Re: 50+50+17.5%=117.5

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Try:

=(50+50)*1.175
or
=(50+50)*117.5%



"T.C." wrote:
>
> Thanks for your help there, I don't think I've explained myself to well
> here, so let me try putting it another way.
> If the government puts a 17.5% tax on every 100 pennies I spend at the point
> of purchase, to buy something for 100 pennies I will need 117.5 penies. Cost
> + Tax IE 100+17.5%=117
> I hope I've explained what it is I'm trying to get at there a little better.
> Once again thanks for your help.
> Regards
> TC
>
> "Bob Umlas" <Excel_Trickster@xxxxxxx> wrote in message
> news:ehPKjdOpFHA.1480@xxxxxxxxxxxxxxxxxxxxxxx
> > =50+50+17.5%.
> > But 17.5% is .175, so the correct answer is 100.175, not 117.5.
> >
> > "T.C." <shadowmere@xxxxxxxxxxxxxxxxxx> wrote in message
> > news:DBoNe.10477$CM.5477@xxxxxxxxxxxxxxxxxxxxxxx
> >> Hi All
> >>
> >> 50+50+17.5%=117.5
> >>
> >> Yep, my problem is that simple, I don't know how to put the sum above
> >> into
> > a
> >> formula in Excel :-( I've been reading a really good book here, tells me
> > how
> >> to format this, resize that, but when it comes to actually doing any
> > maths,
> >> not a word is said :-( So, here are my questions. 1, How do I right the
> >> formula for the above sum? And 2, anybody know of any good places on the
> > net
> >> for teaching how to right the formula in excel.
> >> I'd like to say in advance thanks for any help
> >> Regards
> >> TC
> >>
> >>
> >
> >

--

Dave Peterson
.

Relevant Pages

  • Re: 50+50+17.5%=117.5
    ... If the government puts a 17.5% tax on every 100 pennies I spend at the point ... Regards ... >> Yep, my problem is that simple, I don't know how to put the sum above ...
    (microsoft.public.excel)
  • Re: percentage calculation...trying again
    ... NEXT, SUM, you get 0.00, so two pennies of difference. ... To show that Excel does the same, copy the four number above, FORMAT the ... shows that what appears as 0 did sum as 2 pennies. ... with the calculation involving freight and sales tax. ...
    (microsoft.public.access.queries)
  • Re: Code for SUM with duel criteria
    ... Regards, ... Tom Ogilvy wrote in message ... >> then sum the value. ... >> I can do it for one criteria but not for the two criteria. ...
    (microsoft.public.excel.programming)
  • Re: need to narrow down value
    ... and got the error: ORA-00909: invalid number of arguments ... Also, argument of SUM() may be an expression, but not the list. ... Best regards ... However, i wonder, how can one work with Oracle without having access to Oracle documentation. ...
    (comp.databases.oracle.server)
  • Re: Hourly volume calculation
    ... Best regards. ... "Tom Ellison" wrote: ... field consisting multiple volume entries. ... I need to sum up the volumes by ...
    (microsoft.public.access.queries)