How to Exactly Match amount with Old Price

[avk]

I have enter Old Mrp in "B1" Rs.1976/- & New Mrp in "B2" 2038/- & enter formula in "B3" for difference percentage between old & new mrp.
=SUM(B2*100)/B1-100
Result is : 3.14%

Now i have calculate with new mrp 2038/- with percentage 3.14% with formula =SUM(B2*B3)/100 amount result is Rs. 63.99

If you less Rs. 63.99 from new mrp 2038/- = 1974.01

The difference is Rs. 1.99 (1976/- less 1974.01)

How to exactly match with old mrp.

[samba_ravi]

Instead of =SUM(B2*100)/B1-100
Try=100-B1/B2*100

[Ace_XL]

That's because the % increase is based on your old price i.e. 1976. As a %age of new price, the increase is 3.04% and not 3.14%

The difference is as below

Based on old price
=(B2-B1)/B1

Based on new price
=(B2-B1)/B2

Formatted as %

[etaf]

the 3.14% is related to the Old price NOT the new price

So 1972*3.14% = 62
1972*62 = 2038

so to work out the value using just the new value 2038 and the % 3.14%

=2038/ (1+0.0314)
= 1972

[avk]

Thanks nflsales