What formula do I use to find a percentage change? in Excel General Questions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
buzy lizzy 9/14/2005 9:53 AM PST
  Question
  I'm new to using Excel and I just need to find a formula to use that will
calculate a percentage change from one cell to another.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Anne Troy 9/14/2005 10:09 AM PST
  Answer
  I think you can use this, Lizzy: =(A2-A1)/A1
************
Anne Troy
www.OfficeArticles.com

"buzy lizzy" <buzy lizzy@discussions.microsoft.com> wrote in message
news:CD2BACED-4C91-4204-A897-5801339C3D40@microsoft.com...
> I'm new to using Excel and I just need to find a formula to use that will
> calculate a percentage change from one cell to another.


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
JE McGimpsey 9/14/2005 10:24 AM PST
  Answer
  One way:

=(A2-A1)/A1

formatted as a percentage, which can be simplified to

=A2/A1 - 1

also formatted as a percentage.

In article <CD2BACED-4C91-4204-A897-5801339C3D40@microsoft.com>,
"buzy lizzy" <buzy lizzy@discussions.microsoft.com> wrote:

> I'm new to using Excel and I just need to find a formula to use that will
> calculate a percentage change from one cell to another.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Janie 8/25/2008 10:55 AM PST
   
  Hi Litty
I am rally trying but no luck. what is the percentage?
E6 F6 =% difference of those two below?
1.06 0.98 =SUM(E6:F6)


"buzy lizzy" wrote:

> I'm new to using Excel and I just need to find a formula to use that will
> calculate a percentage change from one cell to another.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
ward376 8/25/2008 12:48 PM PST
   
  =ABS(1-(E6/F6))

Cliff Edwards

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies