Thread
:
An oddity if not a bug
View Single Post
#
18
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
Nick Hodge
external usenet poster
Posts: 1,173
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.
Reply With Quote
Nick Hodge
View Public Profile
Find all posts by Nick Hodge