Re: [libreoffice-users] [Calc bug? ] Function "RANK() " ranks error?

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: users+unsubscribe@global.libreoffice.org
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