View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Miller
 
Posts: n/a
Default Finding the percentage difference of two or more numbers


For what you want, column B is not significant. Therefore, place this
in D1:
(C1-A1)/A1 and format it as a percentage.
slr Wrote:
Column A Column B Column C
A1 = 345 B1=514 C1 = 231

I want to know the percentage of difference between all 3 and place
the
result the percentage (growth or decline %) in Column D1


--
slr
------------------------------------------------------------------------
slr's Profile:
http://www.excelforum.com/member.php...o&userid=25609
View this thread:
http://www.excelforum.com/showthread...hreadid=504939



--
Bob Miller