ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - % (https://www.excelbanter.com/excel-worksheet-functions/203811-%25.html)

debs27

How do I get what % increase is between column a and column b?

HARSHAWARDHAN. S .SHASTRI[_2_]

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

================================================== ===========

"debs27" wrote:

How do I get what % increase is between column a and column b?

Peo Sjoblom[_2_]

=(B8-A8)/A8

format as percentage

--

Regards,

Peo Sjoblom

"debs27" wrote in message
...
How do I get what % increase is between column a and column b?

David Biddulph[_2_]

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
--
David Biddulph

"HARSHAWARDHAN. S .SHASTRI"
wrote in message
...
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

================================================== ===========

"debs27" wrote:

How do I get what % increase is between column a and column b?

HARSHAWARDHAN. S .SHASTRI[_2_]

You are correct.

================================================== ========

"David Biddulph" wrote:

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
--
David Biddulph

"HARSHAWARDHAN. S .SHASTRI"
wrote in message
...
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

================================================== ===========

"debs27" wrote:

How do I get what % increase is between column a and column b?

All times are GMT +1. The time now is 09:59 AM.