Percentage Change Formula For Negative Numbers.xlsx (19.8 KB) What if the numbers are Negative?Īfter a bit of research, I have not found a good way to calculate the percentage change when either the old number or the new number are negative. This formula can also be used to calculate discount percentages. This could be time periods, entities, categories, businesses, etc. The goal of the percentage change formula is to allow us to make comparisons on performance between two or more items. The one you use is just a matter of personal preference. Formula #1 =(new value – old value) / old value Formula #2 =(new value / old value) – 1īoth of these formulas will produce the same result when the numbers are positive. I also explained two formulas we can use to calculate percentage change. In my last post I shared a macro to quickly create percentage change formulas. Bottom line: Learn how to create percentage change formulas in Excel with negative numbers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |