99 - -1-1 x 100 -100. Increase Increase Original Number 100. Here is the formula that is commonly used.
If the previous value was negative 1 and the current value is positive 99 then this happens.
How to calculate percent variance for negative numbers If some of the original values are represented by negative numbers the above formulas wont work. 2 Using cell references instead of numbers in the formula. 99 - -1-1 x 100 -100. One common way to calculate percentage change with negative numbers it to make the denominator in the formula positive.