Calculate percentage changes for containing negative numbers and zero

For calculating the % change which doesn't contain a negative or zero value we can use one of these two formulas

1. (new value – old value) / old value

2. (new value / old value) – 1

Why is a custom function required?

1. When the data set has 0 values then the above formula will run into #DIV error.

2. When the data set has negative values or to calculate negative growth

What do we know as a basic math

• 0 can't be divided by any number

• A number can't be divided by 0

• Changes from 0 to any positive number will be a 100% increase

• Changes from a positive value to 0 will be a 100% decrease