View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default An oddity if not a bug

In your previous post on
=MOD((A1-A2),1)
1.4210854715202E-14


It appears that lone bit is a "large" error.

=POWER(2,-46)
1.4210854715202E-14
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"Biff" wrote in message
...
That's the "fudge factor" Harlan was talking about.


<snip