| 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. |
| 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) | |||
Threaded Mode
