View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default An oddity if not a bug

Biff wrote...
this is still a bug. COMBIN should *only*
return integers or error values.


I agree and had always assumed as much. This little exercise proves
otherwise.

=MOD((COMBIN(9,3)-84),1)

Returns 1.

....

Actually, it returns 0.999999999999986. And don't get me started on
MOD.

With all boils in need of lancing in Excel, what does Microsoft do?
Give it a nose job.