<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