View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Calculating a percent decrease

Because that's the way percentages work.

If you invest $100, and lose 25%, you end up with $75. But from there, you
need a 33% return to get your money back.

Or, if the Canadian dollar drops from par to 80 cents, it's dropped 20%. But
to get from there back up to par, it has to increase 25%.

When your base is $15.00, 8% is $1.20. But when your base is $13.80, 8% is
only $1.10.

Regards,
Fred.

"Karen" wrote in message
...
I am working on a spreadsheet which calcualtes a decrease in base wages,
which is working fine: A1*(1-A2)= X or $15.00 *(1-8%) = $13.80. Howeever,
when I work the formula in reverse, I don't get my original number: $13.80
*
8% = $14.90. Why is that? Thank you.