Excel - How can I find the percent differnce between two numbers?

Asked By trainer0 on 16-Dec-08 05:47 PM
I have two columns of numbers.  I want to write a formula that calculates the
percent difference between the two numbers.  Any assistance would be
appreciated.




Mike replied on 16-Dec-08 06:04 PM
Maybe

=(A1-B1)/A1

Mike
David Biddulph replied on 16-Dec-08 06:04 PM
=(B2/A2)-1 and format as percentage.
--
David Biddulph