Forum Discussion
looking to create a formula for the percentage difference between two numbers
Hi experts, I have two columns the first is the old percentage and the second is the new percentage. I want to create a 3rd column that would show the percentage difference but I keep getting the wrong number. Is there a way the two columns with the old and new percentages should be formated for the formula to work correctly? What should the formula be in the 3rd column?
2 Replies
If I understand the goal correctly, you might use one of the newer functions PERCENTOF:
=PERCENTOF(B2,A2)Let's say A2 contains 40% and B2 contains 60%.
The difference between A2 and B2 is =B2-A2
This will return 20%.
Or do you want the difference as a percentage of the first value? That would be =(B2-A2)/A2
That results in 50% in the above example.
