Prev: Hide formula in list
Next: How to enable auto height with merged cells?
From: christie on 18 Mar 2010 11:16
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
From: trip_to_tokyo on 18 Mar 2010 11:28
Try this:-

=((A1-B1)/A1)*100

If my comments have helped please hit Yes.

Thanks.




"christie" wrote:

> 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
From: Amish on 18 Mar 2010 11:45
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.

On Mar 18, 11:16 am, christie <chris...(a)discussions.microsoft.com>
wrote:
> 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

From: Fred Smith on 18 Mar 2010 12:07
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

"christie" <christie(a)discussions.microsoft.com> wrote in message
news:350A377C-8C60-4B38-A487-4B14B8BFC7C3(a)microsoft.com...
> 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

From: Fred Smith on 18 Mar 2010 12:09
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

"trip_to_tokyo" <info(a)pierrefondes.com> wrote in message
news:5D233C5D-9A31-41C9-ACFE-EFC251CA8698(a)microsoft.com...
> Try this:-
>
> =((A1-B1)/A1)*100
>
> If my comments have helped please hit Yes.
>
> Thanks.
>
>
>
>
> "christie" wrote:
>
>> 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

 | 
Pages: 1
Prev: Hide formula in list
Next: How to enable auto height with merged cells?