MAX D4-E4 0 Explanation. We could use this same methodology to tell our readers if the change was positive P or negative N when either value is negative. 1 Calculate the change of negative numbers by making the denominator absolute.
Here is the formula that is commonly used.
Sometimes finance deals with negative quantities that become less negative over time. In the Format Cells window switch to the Number tab. Sometimes finance deals with negative quantities that become less negative over time. C4-B4ABS B4 The figure uses this formula in cell E4 illustrating the different results you get when using the standard percent variance formula and the improved percent variance formula.