HIKE %
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/tutorials...taadapter.aspx |
HIKE %
<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 |
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 . |
All times are GMT +1. The time now is 04:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com