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