Calculate Percentage Change for negative numbers in Excel. So 4 contributes 40 and 6 contributes 60 to their sum 10. The first is to find the ratio of the amount of change to the original amount.
Increase Increase Original Number 100.
Work out the difference increase between the two numbers you are comparing. 1 Calculate the change of negative numbers by making the denominator absolute. Percentage difference is usually calculated when you want to know the difference in percentage between two numbers. The ABS function is used in Excel to change the sign of the number to positive or its absolute value.