Finding the percentage difference of two or more numbers

S

slr

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
 
R

Ron Coderre

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,
Ro
 
G

gailann

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"))
 
S

slr

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show Difference as a Percentage 1
difference in numbers displayed as a +/- percentage 3
Percentage 2
Difference 6
Percentage difference between two numbers 1
How do you calculate a negative percentage 2
% of difference between two numbers 6
Percentages between two cells 1

Top