Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Computing percent changes in Excel between two values
I work at a police department and we track #'s of certain crimes and then
monthly report the percentage of change from, for example, January 2006 murders vs January 2007 murders. I'm looking for the formula to enter into the cell that will compute the percentage change taking into account that Jan 2006 could be 0 (zero) and/or Jan 2007 could be 0 (zero). Is it as simple as (A2/A1)-1 ??? Should the formula include more in depth with "if/then" statement to account for the possibility of a 0 in either A1 or A2? I'm new to the job with no on the job trainer and the current formula in the "change" column is probably over 100 characters in length with six "If" included... and it doesn't work. Thanks for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I change all values in a spreadsheet by a certain percent | Excel Discussion (Misc queries) | |||
Computing averages excluding values with no value | Excel Worksheet Functions | |||
Formatting a number to look like a Percent without a percent sign | Excel Discussion (Misc queries) | |||
Algorithm for computing Excel PercentRank | Excel Worksheet Functions | |||
Is there a way to have two values (percent and number) in a label. | Charts and Charting in Excel |