Your range is moved as well : =RANK(B5;B5:B8) should be =RANK(B5;B2:B5)
Met vriendelijke groeten, Salutations distinguées, Kind Regards, DRIES FEYS CORPORATE SERVICES • Specialist Software Developer TVH GROUP NV Brabantstraat 15 • BE-8790 WAREGEM T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com On 13 November 2013 13:38, minhsien0330 <[email protected]> wrote: > Dear all: > I want rank some score. > There are 4 scores : 92.6, 93.6, 98.2 and 95.2 > It's strange that the function "RANK() " rank 95.2 as "no. 1" > > You can download this ods file to test: > https://sites.google.com/site/minhsien0330/test/RANK_PROBLEM.ods?attredirects=0&d=1 > > Is this a bug? > > Thank you~ > > Regards Minhsien0330 > > -- > To unsubscribe e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted > -- **** DISCLAIMER **** http://www.tvh.com/newen2/emaildisclaimer/default.html "This message is delivered to all addressees subject to the conditions set forth in the attached disclaimer, which is an integral part of this message." -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
