Den tors 26 nov. 2020 kl 10:03 skrev stmoose <st.mo...@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+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/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy