| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate the difference between two percentages
does anyone know what formula can be used for this...
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate the difference between two percentages
I wonder if your question is a bit more complex than it appears.
60% - 50% results in an answer of 10%. Quite simple and straight forward. Have you got all the cells formatted as percentage? If the above is not what you are trying to do then post an example of what you want to do including the the formula you are using and the answer you are getting. Regards, OssieMac "coyote" wrote: does anyone know what formula can be used for this... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate the difference between two percentages
From 50 to 60 is a 20% increase.
From 60 to 50 is a 16.6666% decrease Is that what you mean? Gord Dibben MS Excel MVP On Fri, 10 Aug 2007 21:02:02 -0700, OssieMac wrote: I wonder if your question is a bit more complex than it appears. 60% - 50% results in an answer of 10%. Quite simple and straight forward. Have you got all the cells formatted as percentage? If the above is not what you are trying to do then post an example of what you want to do including the the formula you are using and the answer you are getting. Regards, OssieMac "coyote" wrote: does anyone know what formula can be used for this... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i can't figure out how to calculate percentages in excel | New Users to Excel | |||
| How do I calculate percentages in a pivot table? | Excel Discussion (Misc queries) | |||
| How do I Calculate Percentages for each number in a column? | Excel Discussion (Misc queries) | |||
| When subtotaling can Excel also calculate percentages | Excel Worksheet Functions | |||
| calculate percentages | Excel Worksheet Functions | |||
Linear Mode
