| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding the percentage difference of two or more numbers
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding the percentage difference of two or more numbers
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: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=504939 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding the percentage difference of two or more numbers
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(A2A1,"+",IF(A2<A1,"-","No Change")) -- gailann ------------------------------------------------------------------------ gailann's Profile: http://www.excelforum.com/member.php...o&userid=30798 View this thread: http://www.excelforum.com/showthread...hreadid=504939 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding the percentage difference of two or more numbers
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding the percentage difference of two or more numbers
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| formulas to numbers | New Users to Excel | |||
| how do i get annual percentage difference reports in excel | Excel Discussion (Misc queries) | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
| DECREASE ALL NUMBERS IN A COLUMN BY A PERCENTAGE | Excel Worksheet Functions | |||
Linear Mode
