D
debs27
How do I get what % increase is between column a and column b?
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.
H
HARSHAWARDHAN. S .SHASTRI
Suppose a2 cell value is 100 and b2 cell value is 120 then write down
following formula in cell c2
= (b2-a2)*100/b2
Harshawardhan.Shastri
=============================================================
following formula in cell c2
= (b2-a2)*100/b2
Harshawardhan.Shastri
=============================================================
P
Peo Sjoblom
=(B8-A8)/A8
format as percentage
--
Regards,
Peo Sjoblom
format as percentage
--
Regards,
Peo Sjoblom
D
David Biddulph
In my book, that is a 20% increase, not a 16.67% increase. It would be more
conventional to divide by the *original* value, A2, rather than by B2.
Also, it is often more sensible not to multiply by 100 but merely to format
as percentage. That way, the percentage can be used in subsequent
calculations without having to divide by 100.
Hence, =(B2-A2)/A2 or =B2/A2-1
conventional to divide by the *original* value, A2, rather than by B2.
Also, it is often more sensible not to multiply by 100 but merely to format
as percentage. That way, the percentage can be used in subsequent
calculations without having to divide by 100.
Hence, =(B2-A2)/A2 or =B2/A2-1
H
HARSHAWARDHAN. S .SHASTRI
You are correct.
==========================================================
==========================================================