Thursday 22 August 2013

Excel - How to calculate percentage difference between 2 cells



A1 = 232
B1 = 23
=(B1/A1)-1    then convert cell to percentage - will tell me how much more b needs to get to a
=(B1/A1)    then convert cell to percentage - will tell me b is what percentage of a

No comments:

Post a Comment