| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
%
How do I get what % increase is between column a and column b?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
%
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
%
=(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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
%
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
%
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
