HIKE %

[AMIT BHOPAL]

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



Submitted via EggHeadCafe - Software Developer Portal of Choice
TEST SNIPPET- DataAdapter Handler
http://www.eggheadcafe.com/tutorial...ed-4f7de850c2b0/test-snippet-dataadapter.aspx

 

[Joe User]

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 -----

 

[JLatham]

Wal-Mart "roll-backs"? <bg>

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 -----



.