https://lists.oasis-open.org/archives/office-comment/201608/msg00001.html Looking at the source code revealed that we constrain on 0 < Alpha < 1, so does Excel, but Gnumeric does not. Follow-up question posted with https://lists.oasis-open.org/archives/office-comment/201608/msg00002.html it must be 0 <= alpha <= 1. Both 0 and 1 are valid values for accumulated binomial distributions. As far as the code is concerned, these are probably special cases which must be handled separately, as both 0 and 1 are asymptotes. Winfried will change the code.
Let's set to NEW.
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f613f6e6973b2069c5f4c5b56efa4c355118387e tdf#102212: correct constraints for Calc functions CRITBINOM, BINOM.INV. It will be available in 5.3.0. 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.