View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
asb3stos
 
Posts: n/a
Default What's wrong with this formula?


Hi everyone, i'm making a formula for Spearsmans Rank Correlation and
I've made a realtively simple formula for a part of it but it's not
working and I can't spot what's wrong with it.

=1-(6*G98)/(ROWS(B83:B102))*(POWER((ROWS(B83:B102),2))-1)

Can anyone help me, i'm dying here! Cheers!
(the references are all correct, maybe it's the brackets?)


--
asb3stos
------------------------------------------------------------------------
asb3stos's Profile: http://www.excelforum.com/member.php...o&userid=35545
View this thread: http://www.excelforum.com/showthread...hreadid=553073