software

I need to find the difference of 2 or more numbers and then show the
percentage quot; or -quot; 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: www.excelforum.com/member.php...oamp;userid=25609
View this thread: www.excelforum.com/showthread...hreadid=504939
If your data is in Cells A1:A3, then
B2: =(A2-A1)/A1
Format that cell as Percent

Then, copy B2 down as far as needed.

Does that help?

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=504939
If you want to show just that attendance has either increased or
decreased by a or -, use this:

(If your data is in Cells A1:A3, then
B2: =IF(A2gt;A1,quot; quot;,IF(A2lt;A1,quot;-quot;,quot;No Changequot;))--
gailann
------------------------------------------------------------------------
gailann's Profile: www.excelforum.com/member.php...oamp;userid=30798
View this thread: www.excelforum.com/showthread...hreadid=504939
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: www.excelforum.com/member.php...oamp;userid=25609
View this thread: www.excelforum.com/showthread...hreadid=504939
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:
gt; I need to find the difference of 2 or more numbers and then show the
gt; percentage quot; or -quot; in a separate cell.
gt;
gt; For example, if wanted to see the growth or decrease of a club
gt; attendance for 3 yrs.
gt;
gt; Year 1 = 345
gt; Year 2 = 514
gt; Year 3 = 231
gt;
gt;
gt; --
gt; slr
gt; ------------------------------------------------------------------------
gt; slr's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25609
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=504939--
Bob Miller


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:
gt; Column A Column B Column C
gt; A1 = 345 B1=514 C1 = 231
gt;
gt; I want to know the percentage of difference between all 3 and place
gt; the
gt; result the percentage (growth or decline %) in Column D1
gt;
gt;
gt; --
gt; slr
gt; ------------------------------------------------------------------------
gt; slr's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25609
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=504939--
Bob Miller