View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default An oddity if not a bug

Harlan

That shows how marketing rules the roost... they'd rather have a nose job
than the boils lanced ;-) loved the analogy though

The devs would love to fix everything, it's just fixes don't sell <shrug

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Harlan Grove" wrote in message
ups.com...
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.