Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have Excel 2003 (11.8237.8221) SP3 according to the ABOUT screen in the
HELP menu. The three numbers and their cell locations a F17 = 1887.36 F18 = 314.56 F21 = 314.56 Note that 314.56 x 6 = 1887.36, so why is this happening? The formula =(1887.36-314.56)/314.56 equals 5 but the formula =MOD(1887.36-314.56,314.56) equals -5.68434E-14 (for this next one I formatted the digits in the Excel cell as far as I thought good) The formula =(F17-F18)/F21 equals 5.000000000000000 but the formula =MOD(F17-F18,F21) equals 0.000000000000171 Why? How do I fix it? - Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 - Calculation Problems | Excel Discussion (Misc queries) | |||
Excel 2003 - Problems with calculation | Setting up and Configuration of Excel | |||
Problems with Excel 2003 - Dashboards | Charts and Charting in Excel | |||
Problems with Excel 2003 - Dashboards | Excel Discussion (Misc queries) | |||
Problems with Excel 2003 | Setting up and Configuration of Excel |