Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
![]()
A1:
=FACT(9)/FACT(6)/FACT(3) returns 84, as it should A2: =COMBIN(9,3) returns 84, as it should A3: =A1=A2 returns TRUE A4: =A1-A2 returns 0 A5: =MOD(A4,1) returns 0 A6: =MOD(A1,1) returns 0 A7: =MOD(A2,1) returns -1.42109E-14 So the @#$% fudge factor strikes again, or does it? Shouldn't it affect the evaluated value of cell A2 with the final result for A2 an integer? This shouldn't be. If cell A4 is zero with no remainder in A5, why should A7 have a remainder? Same results in 2003 and 2007. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Reference Oddity | Excel Discussion (Misc queries) | |||
Chart oddity | Charts and Charting in Excel | |||
Save as HTML oddity | Excel Worksheet Functions | |||
Excel2000 ODBC query oddity | Excel Discussion (Misc queries) | |||
Another Excel oddity | Excel Discussion (Misc queries) |