Re: 50+50+17.5%=117.5

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

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
>>
>>
>
>


.

Relevant Pages

  • Re: 50+50+17.5%=117.5
    ... to buy something for 100 pennies I will need 117.5 penies. ... >>> Yep, my problem is that simple, I don't know how to put the sum above ... >>> Regards ... Dave Peterson ...
    (microsoft.public.excel)
  • How to get rid of pennies
    ... To get rid of pennies, all we ... If businesses were to add the sales tax to the ticket price, ...
    (rec.collecting.coins)
  • Re: How do I determine calendar quarters in Access ?
    ... If you wish to sum across a different time frame than you are grouping on, ... would like to use a template that would allow me to subtotal payroll data ... (hours worked, SS Tax, Med Tax, Fed Inc Tax, etc.) ... and segregating them into the repective calendar quarters. ...
    (microsoft.public.access.queries)
  • Re: Calculating tax Formula
    ... First CHOOSEreturns the tax value at percentage change level, your sum ... I have seen in some of Excel NG's easier formulas too, ...
    (microsoft.public.excel.misc)
  • Re: Why not FP for Money?
    ... >> same rounding in every country. ... > calculate interest, tax, etc, they want to deal in fractional pennies. ... of which calculating withholding tax for US tax returns is ...
    (comp.lang.python)