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

On 26/11/2020 04:09, stmoose wrote:
> 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?
The 2 in your formula is the rank. Because you have 7 identical values of 323 in your data, the 
formula will not return 322 until you change it to =LARGE(B4:Z4,8)

Philip


--
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