See https://bugs.freedesktop.org/attachment.cgi?id=88108 of meta bug 70798 for test case.
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e362bc7892e0fd193e541838be4bd26b7ff42fdd fdo#71081 add Excel 2010 functions BINOM.DIST and BINOM.INV The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 74565 has been marked as a duplicate of this bug. ***