Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculations don't compute...
Here's what I have...
A1 B1 C1 16.16 =((c1-a1)/2)+a1 24.44 Which, of course, gives us the value of 20.3 in cell B1, which is the mid-point between the values in cells A1 and C1. However, why do I get different percentages when I calculate a1/b1 and b1/c1? Shouldn't the percentage be the same if the difference between the numbers is the same? Thanx. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculations don't compute...
Well, it shouldn't... :)
1/10 is different from 91/100, right? The difference between them is the same (9), and so is the percentage... Regards! "Steven Sinclair" escreveu na mensagem ... Here's what I have... A1 B1 C1 16.16 =((c1-a1)/2)+a1 24.44 Which, of course, gives us the value of 20.3 in cell B1, which is the mid-point between the values in cells A1 and C1. However, why do I get different percentages when I calculate a1/b1 and b1/c1? Shouldn't the percentage be the same if the difference between the numbers is the same? Thanx. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculations don't compute...
You would get the same percentage if B1 was the geometric mean of A1 and C1,
but you've got the arithmetic mean. You can get the geometric mean by =SQRT(A1*C1) or =(A1*C1)^0.5 or =GEOMEAN(A1,C1) You will, I hope, realise that your arithmetic mean could have been calculated, rather than =((C1-A1)/2+A1), as =(A1+C1)/2 or as AVERAGE(A1,C1) -- David Biddulph "Steven Sinclair" wrote in message ... Here's what I have... A1 B1 C1 16.16 =((c1-a1)/2)+a1 24.44 Which, of course, gives us the value of 20.3 in cell B1, which is the mid-point between the values in cells A1 and C1. However, why do I get different percentages when I calculate a1/b1 and b1/c1? Shouldn't the percentage be the same if the difference between the numbers is the same? Thanx. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
order of calculations in Excel | Excel Worksheet Functions | |||
Counting the number of calculations on a speadsheet | Excel Discussion (Misc queries) | |||
complex calculations | Excel Discussion (Misc queries) | |||
Calculations based on PivotTable information | Excel Discussion (Misc queries) | |||
Calculations crossing multiple sheets | Excel Discussion (Misc queries) |