Microsoft 2007

  • Thread starter Thread starter christie
  • Start date Start date
C

christie

What is the formula for a percent change between 2 cells?
Everything I am trying will not work with the 2007 version. I have used the
formula I know in an older version and it worked fine.
Please help
 
Try dividing. We use the % sign because it is something divided by
something else, like 1/2.

Note that percents are expressed as decimals, so 1/2 = .5 = 50%; be
very careful about multiplying by 100 because 1/2 is not equal to 50 -
using the percent style to display .5 as 50% is the common way to
present this.
 
Nothing changed between Excel 2007 and earlier versions with respect to
calculating percentages. It's always been:

1. Calculate the difference, as in: a2-a1
2. Divide by the original, as in: (a2-a1)/a1
3. Format as percentage.

Regards,
Fred
 
Multiplying by 100 to calculate a percentage makes it difficult to use the
number in future calculations. You're almost always better off formatting as
a percentage instead.

Regards,
Fred
 
Back
Top