If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Microsoft 2007
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 |
#2
|
|||
|
|||
Microsoft 2007
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 |
#3
|
|||
|
|||
Microsoft 2007
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 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 |
#4
|
|||
|
|||
Microsoft 2007
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" wrote in message ... 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 |
#5
|
|||
|
|||
Microsoft 2007
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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|