Percentages

S

shalamar2007

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

Gary''s Student

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
 
Top