If you data is in A1, A2, A3 respectively then, in B2 put =(A2-A1)/A1
and copy this to all the cells below adjacent to data in an A column
cell. Format column B to %.
slr Wrote:
I need to find the difference of 2 or more numbers and then show the
percentage "+ or -" in a separate cell.
For example, if wanted to see the growth or decrease of a club
attendance for 3 yrs.
Year 1 = 345
Year 2 = 514
Year 3 = 231
--
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