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
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
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
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(A2>A1,"+",IF(A2<A1,"-","No Change"))
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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks