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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I find the percent differnce between two numbers? (https://www.excelbanter.com/excel-discussion-misc-queries/213891-how-can-i-find-percent-differnce-between-two-numbers.html)

trainer07

How can I find the percent differnce between two numbers?

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 H

How can I find the percent differnce between two numbers?

Maybe

=(A1-B1)/A1

Mike

"trainer07" wrote:

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.

David Biddulph[_2_]

How can I find the percent differnce between two numbers?

=(B2/A2)-1 and format as percentage.
--
David Biddulph

"trainer07" wrote in message
...
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.

All times are GMT +1. The time now is 01:54 AM.