Percentages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to find the percentage difference of the price variance for two line
items then turn it into either a positve or negative percent?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting cells from a table 6
if format problem 9
VARIANCE PERCENT 1
Percentage Increase 13
formula to calculate a specific percent of a column of different p 1
Formula w/negative no.s & Percentage 2
Divide two cells and if the number is negative display is as zero 2
Pivot Tables & Conditional Formatting 2

Back
Top