excel help https://support.office.com/en-US/article/BETA-DIST-function-11188C9C-780A-42C7-BA43-9ECB5A878D31 -> If x < A, X > B, or A = B, BETA.DIST returns the #NUM! error value. The formula =BETA.DIST(12,8,10,1,1,3) -> 12>3. the row 20 should be error too, =BETA.DIST(1,8,10,1,2,3) -> x<A 1<2 , but Calc returns 0 . Syntax BETA.DIST(x,alpha,beta,cumulative,[A],[B])
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=46f09cb1252078ef23ed93a3551acbdcca9d31cd tdf#101855 BETA.DIST: apply same constraints as Excel does. 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.
> -> If x < A, X > B, or A = B, BETA.DIST returns the #NUM! error > value. The formula =BETA.DIST(12,8,10,1,1,3) -> 12>3. >the row 20 should be error too, =BETA.DIST(1,8,10,1,2,3) -> x<A > 1<2 , but Calc returns 0 . With Version: 5.3.0.0.alpha0+ Build ID: e043b12b4b81a54d6936f62cd77475395c7983a6 CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-09-17_06:50:47 I now get Err:502