View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
paul[_2_] paul[_2_] is offline
external usenet poster
 
Posts: 31
Default What formulae do I use to get a percentage going back down.

you need to know that 17.5 percent WAS applied(ie 100*1.175),or know what the
original starting price was.You get back to your original starting price by
dividing by 1.175 or determine your original increase by(117.5-100)/100
--
paul

remove nospam for email addy!



"Eqa" wrote:

If I have a figure to which I have to apply an additional 17.5% say $100 so
that it eqals $117.5. What formula do I use to work out what the original
starting price was when I am confronted by $117.50 ie I want to get back to
the $100 figure. So in this case 17.5% up is what formula to go down and
what is the rule for going down from an number.

Hope this clear and much thanks.

Eqa