Hello Olivier and Steve,
The function WORKDAY in help pages and also its implementation has only the
first 3 parameters whereas ODF section has 4 parameters. Also ODF mentions
passing {0;0;0;0;0;1;1} or {1;0;0;0;0;0;1} or even this {0;0;0;1;1;1;1} as
the Holiday parameter which when I tried does not change the result.
I have stated that "Calc's implementation of WORKDAY function is not
strictly in accordance with ODF 1.2." in wiki.
Calc's function works just like MS Excel's function does.
Regards,
Ronnie Gandhi
Undergraduate at Computer Science and Engineering
Indian Institute of Technology, Roorkee
+91-07874243430
On Sun, Oct 4, 2020 at 11:35 PM GANDHI RONNIE <gron...@cs.iitr.ac.in> wrote:
> Hello Olivier and Steve,
>
> I could sense an error on the help pages for BETA.INV and BETAINV
> function. The definition of Number is wrong. It states Number to be between
> Start and End but actually it is the probability which is associated with
> BETA function for other given arguments and the output will be that Number.
>
> Compare it with MS excel equivalent
> https://support.microsoft.com/en-us/office/beta-inv-function-e84cb8aa-8df0-4cf6-9892-83a341d252eb
> .
>
> Actually out function works the same way but the description of this
> Number is wrong.
>
> One eg to prove the point is : =BETA.INV(0.5,3,4,3,4) gives
> 3.42140719069071
>
> But =BETA.INV(3.5,3,4,3,4) gives Err:502 which infact qualifies the
> definition.
>
> Ronnie Gandhi
> Undergraduate at Computer Science and Engineering
> Indian Institute of Technology, Roorkee
> +91-07874243430
>
--
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy
