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