Calculation of reducing price by a percentage and adding back

[Caly]

If i have a price of 55.28 but need to add 4% to that but need to make sure that when 4% is then removed that the price remains at 55.28. So what I did was =round(55.28 / (1-4%),2) which comes to 57.58.... and then doing =round(57.58 * (1+4%),2) equals the 55.28.... but is that right to do? Not sure if customer may just take the 55.28 and add 4% to that which would come to 57.49 but then taking 4% out from 57.49 does not equal 55.28 and instead equals 55.19... but is there a way to explain that?

 

[awoohaw]

Im not sure what youre trying to do is possible. Once you round a value, you lose all the intervening decimal portions that have been removed:

mr excel questions 20.xlsm
	A	B
1
2	2.2049	2.20
3	2.205	2.21
4	2.2148	2.21
5	2.2149	2.21
6	2.215	2.22
Caly

Cell Formulas
Range	Formula
B2:B6	B2	=ROUND(A2,2)

 

[Caly]

Thank you. But I’m trying to explain the calculation for adding in a percentage in order to then remove it but ensure the original number is met.
-why does using the formula =round(55.28 / (1-4%),2) equal an answer of 57.59, that when using formula =round(57.58 * (1+4%),2) equals the 55.28?
-why does not taking the 55.28 which is the resulting price needed after removing the percentage, work when using the price multiplied by 1+the percentage rate?


starting Price when percentage is removed
55.28

Resulting answer of applying 4% to 55.28 using this formula =round(55.38/(1-4%),2)
57.58

Removing 4% from 57.58 using formula =round(57.58*(1-4%),2)
55.28

 

[AlphaFrog]

This works

=ROUND(55.28 *104%, 2)

=ROUND(57.49 /104%, 2)