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 wr...
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.