| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
% Change
How can I show the percentage of change from one amount to the next, e.g. the
percentage of change from one year's payroll totals to the next? -- Nerdy Girl |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
% Change
In article ,
Nerdy Girl wrote: How can I show the percentage of change from one amount to the next, e.g. the percentage of change from one year's payroll totals to the next? Assuming that A2 contains the first year's total, and B2 contains the second year's total, try... =(B2-A2)/A2 -- Domenic http://www.xl-central.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change formula in shared sheet without loss of change histo | Excel Worksheet Functions | |||
| change scaling % but font size didnt change porportionally, pls he | Excel Discussion (Misc queries) | |||
| Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| making copied cells change with change in original cell | Excel Worksheet Functions | |||
Linear Mode
