Reply
Sat 31 Jul, 2004 11:28 pm
In excel, I'm trying to create a formula to calculate the percentage difference between to numbers in adjacent columns.
I.e.
Cell A1 contains the number 79.05
Cell B1 contains the number 73.00
I'd like to know how much higher - in percentage, 79.05 is compared to 73.00.
I'd be very grateful if someone could recomend an Excel formula to do this operation. The result would go into Cell C1.
Cheers, all the best.
MB
Click on C1 and type
((a1-b1)/b1)*100
Thanks Gautam
Xclnt - thanks a ton. Much appreciated.
Mike - Montreal
No worries, glad to have helped !