B
buzy lizzy
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.
calculate a percentage change from one cell to another.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Anne Troy
J
JE McGimpsey
One way:
=(A2-A1)/A1
formatted as a percentage, which can be simplified to
=A2/A1 - 1
also formatted as a percentage.
=(A2-A1)/A1
formatted as a percentage, which can be simplified to
=A2/A1 - 1
also formatted as a percentage.
J
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)
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)
W
ward376
=ABS(1-(E6/F6))
Cliff Edwards
Cliff Edwards