| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage increase of one cell to another in Excel?
I am trying to find the percentage difference from one cell to another. Cell
C1 is $89 and cell D1 is $99. What is the formula to find the percentage increase? -- Holly N |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage increase of one cell to another in Excel?
Hi,
In cell E1, type the following formula in the formula bar =(D1-C1)/C1. Ensure that the cell is formatted as %. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Holly" wrote in message ... I am trying to find the percentage difference from one cell to another. Cell C1 is $89 and cell D1 is $99. What is the formula to find the percentage increase? -- Holly N |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage increase of one cell to another in Excel?
=(D1-C1)/C1
returns .11236 or 11.236% increase. Gord Dibben MS Excel MVP On Wed, 3 Dec 2008 14:55:01 -0800, Holly wrote: I am trying to find the percentage difference from one cell to another. Cell C1 is $89 and cell D1 is $99. What is the formula to find the percentage increase? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage increase of one cell to another in Excel?
Hi,
Or an equivalent way to think about this would be =D1/C1-1 where D1 is 99 and C1 is 89 -- If this helps, please click the Yes button Cheers, Shane Devenshire "Holly" wrote: I am trying to find the percentage difference from one cell to another. Cell C1 is $89 and cell D1 is $99. What is the formula to find the percentage increase? -- Holly N |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage increase of one cell to another in Excel?
Much more simple.
Thanks Shane Gord On Thu, 4 Dec 2008 01:11:01 -0800, Shane Devenshire wrote: Hi, Or an equivalent way to think about this would be =D1/C1-1 where D1 is 99 and C1 is 89 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I increase prices in excel by a percentage? | New Users to Excel | |||
| How do I increase a column of numbers by a percentage-same cell | Excel Discussion (Misc queries) | |||
| Increase excel worksheet vlaues by a percentage | Excel Worksheet Functions | |||
| increase the value of a cell by a percentage | Excel Discussion (Misc queries) | |||
| Percentage increase in excel | Excel Discussion (Misc queries) | |||
Linear Mode
