In Excel, using the formula, =(A1-A2)/ABS(A2), it tells me that the percentage difference between 829 (A1) and -17 (A2) is 4,976.47%. By way of further example, Excel is telling me that the difference between 2427 and 270 is 789.89%. Is this correct? If someone could spoon feed this one to me, I'd appreciate it.
2006-07-20 00:17:41 · 5 answers · asked by Anonymous in Science & Mathematics ➔ Mathematics
The KEY is this: %change = change amount divided by where you started. Multiply this by 100 to turn it into a percentage.
1) The difference between 820 and -17 is 846,
2) You'd now have to divide this 846 change by your starting number. The problem is you don't say which was your starting.
(a) If you began with 829, you'd divide the 846 by 829, then multiply by 100 to get 102.05%.
(b) But if you started with the -17, you'd divide the 846 by -17, then multiply by 100 to get 4976.47%.
2006-07-20 07:46:19 · answer #1 · answered by msoexpert 6 · 0⤊ 0⤋
Yes it is correct.
In the first case what excel is saying that the number in A1 is 4,976.47% more than the number in A2.
Similarly in the second case it means that the number in A1 is 789.89% more than the number in A2.
This is how it is to be interpreted.
2006-07-20 07:33:05 · answer #2 · answered by Suraj 3 · 0⤊ 0⤋
Yes!! It tells you the difference is x% of A2
2006-07-20 07:26:57 · answer #3 · answered by kulkarnidg 2 · 0⤊ 0⤋
Yes it's correct.
2006-07-20 07:21:41 · answer #4 · answered by prosperous_lunatic 3 · 0⤊ 0⤋
Thr first one is correct but in the further example, it should be 798.89%
Otherwise its all correct !
2006-07-20 07:36:56 · answer #5 · answered by young_friend 5 · 0⤊ 0⤋