| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel formula calculations are wrong | Excel Worksheet Functions | |||
| Formula retrieves wrong data | Excel Discussion (Misc queries) | |||
| Recalculating Formula - Getting the wrong answers | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Threaded Mode
