Excel Subtracting 3.75% or percentages

[jschoon4]

My questions is I need to subtract 3.75% out of a Price. example

Column A I have 163.47
and in Column B I want my answer after 3.75% is backed out by Mulitpling Column A by .9625

The Problem I have is that when I get my answer in this case in get 157.33 but when you take that answer 157.33 and add 3.75% it does not equate to 163.47. is .9625 correct?

Thanks

 

[Fackouch]

Hi there,
That's not an excel issue looks like. I think you need to multiply 157.33 by (1.0375) to get 163.47. no? (might not match 100% coz of rounding).
Cheers,

 

[jschoon4]

I get 163.23 when I had done that. Is there an excel secret to subtracting percentages? So that when you add the percentage back in you should get the orginal Value. in this case 163.47

 

[jschoon4]

I get 163.23 when I had done that. Is there an excel secret to subtracting percentages? So that when you add the percentage back in you should get the orginal Value. in this case 163.47

I think I will move this question to a Math Forum. Thanks for your efforts

 

[goblin]

This is indeed a math problem and not Excel. You need to revisit your knowledge of percentage calculations.

Start out with $100 and subtract 10%. You now have $90. Add 10% to $90 and you have $99. This is how it is supposed to work. You are not supposed to get back to $100.

If your question is "How much did I have BEFORE I subtracted 10%?" then your thinking needs to go like this:

If X is the amount I had before I subtracted 10% to arrive at value Y, what method did I use to subtract those 10%? You did that with Y = X * 0.9. So if you now have Y and want to get back to X you need to reverse your previous calculation, i.e. Y / 0.9 = X (instead of your current calculation of Y*1.1).