ExcelBanter - Percentages

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Percentages (https://www.excelbanter.com/excel-worksheet-functions/142484-percentages.html)

shalamar2007

Percentages

Trying to find the percentage difference of the price variance for two line
items then turn it into either a positve or negative percent?

Gary''s Student

Percentages

Lets say the initial price is in A1 and the final price is in B1. In C1 enter:
=(B1-A1)/A1 and format as %

if the displayed value is positive then we have a price increase
if the displayed value is negative then we have a price decrease
--
Gary''s Student - gsnu200720

All times are GMT +1. The time now is 08:06 PM.