What formula do I use to find a percentage change?

[Guest]

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.

 

[Anne Troy]

I think you can use this, Lizzy: =(A2-A1)/A1
************
Anne Troy
www.OfficeArticles.com

 

[JE McGimpsey]

One way:

=(A2-A1)/A1

formatted as a percentage, which can be simplified to

=A2/A1 - 1

also formatted as a percentage.

 

[Janie]

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)

 

[ward376]

=ABS(1-(E6/F6))

Cliff Edwards