Re: [libreoffice-users] bug in LARGE function?

Den tors 26 nov. 2020 kl 10:03 skrev stmoose <st.moose@gmail.com>:

> if I have done this correctly, this link (
>
> https://drive.google.com/file/d/1iJ3x4tKNv3Hr9ucYnJqRGWE7Ky8ivfmL/view?usp=sharing
> ) should give you access to a file that I have trying to get the LARGE
> function to work
>
> created in calc 7.0.2.2 since updated to 7.0.3 (but large function not
> working, or at least not how I thought it should :(
>
> a summary of what I have in case you cant download the file
>
> in cell b4 to z4 are values 320, 320, 320, 320, 320, 320, 320, 320, 320
> ,320, 320, 320, 320, 320, 320, 320, 322, 322,323, 323, 323, 323, 323, 323,
> 323
>
> in cell b8 formula =LARGE(B4:Z4,2)   gives the result 323   (but I would
> think that it should return 322? - right?
> i am using the LARGE function incorrectly?

I'm not sure why you expect 322 to be the second largest value when there
are 7 values that are larger than 322.


Kind regards

Johnny Rosenberg


> thanks
>
>
>
>
> --
> Sent from:
> http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
>
> --
> To unsubscribe e-mail to: users+unsubscribe@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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscribe@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/users/
Privacy Policy: https://www.documentfoundation.org/privacy