Hi minhsien0330, Am 13.11.2013 13:38, schrieb minhsien0330:
> 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? No bug! Have a look at the references of your formulae in column C. I guess you did copy the first formula in cell C2 down to C3, C4 and C5. If you do so, you must declare absolute references instead of relative references. Change your formula in C2 from =RANK(B2,B2:B5) to =RANK(B2,B$2:B$5) before copying. :-) Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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
