HIKE %
Wal-Mart "roll-backs"? <bg
"Joe User" wrote:
<AMIT BHOPAL wrote:
WE HAVE TWO COLUMN,ONE HAS OLD PRICE
AND SECOND HAS NEW PRICE.HOW TO FIND
% OF PRICE HIKE.
If A2 is the old price and B2 is new price, the percentage change is:
=B2/A2 - 1
formatted as Percentage. That can also be written:
=(B2-A2)/A2
PS: The phrase "price hike" usually means "price increase". But in all of
your examples, the new price is less than the old price, a "price
reduction". Are the columns mislabeled?
----- original message -----
<AMIT BHOPAL wrote in message
...
Dear Sir,
WE HAVE TWO COLUMN,ONE HAS OLD PRICE AND SECOND HAS NEW PRICE.HOW TO FIND
% OF PRICE HIKE.
OLD PRICE NEW PRICE %OF HIKE.
130.00 92.95
170.00 121.50
106.00 75.80
88.00 40.00
.
|