| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Rank Function
I am using the rank formula:
=RANK(B3;$B$3:$B$74;0) Is there a way to modify the formula so it can calculate the rank when one of my ID's has an #DIV/0! ? ID OCT AVG RANK 005S0F1 64.00 #DIV/0! 017S0B1 7.18 #DIV/0! 050F0OLA 37.75 #DIV/0! 050S0F1 43.20 #DIV/0! 060S0A1 9.08 #DIV/0! 060S0F1 0.00 #DIV/0! 164S0B1 6.00 #DIV/0! 17F0DO 3.25 #DIV/0! 226F0DO #DIV/0! #DIV/0! Thank you in advance. |
|
#2
|
|||
|
|||
|
no,
but your formulas trying to devide by zero which is mathmaticly impossible thus the error. so change your formula that is trying to devide by zero to this. =if(cell=0,""<formula) or instead of "" above, you might put 1. -----Original Message----- I am using the rank formula: =RANK(B3;$B$3:$B$74;0) Is there a way to modify the formula so it can calculate the rank when one of my ID's has an #DIV/0! ? ID OCT AVG RANK 005S0F1 64.00 #DIV/0! 017S0B1 7.18 #DIV/0! 050F0OLA 37.75 #DIV/0! 050S0F1 43.20 #DIV/0! 060S0A1 9.08 #DIV/0! 060S0F1 0.00 #DIV/0! 164S0B1 6.00 #DIV/0! 17F0DO 3.25 #DIV/0! 226F0DO #DIV/0! #DIV/0! Thank you in advance. . |
|
#3
|
|||
|
|||
|
made a mistake.
=if(cell=0,"",formula) sorry. -----Original Message----- no, but your formulas trying to devide by zero which is mathmaticly impossible thus the error. so change your formula that is trying to devide by zero to this. =if(cell=0,""<formula) or instead of "" above, you might put 1. -----Original Message----- I am using the rank formula: =RANK(B3;$B$3:$B$74;0) Is there a way to modify the formula so it can calculate the rank when one of my ID's has an #DIV/0! ? ID OCT AVG RANK 005S0F1 64.00 #DIV/0! 017S0B1 7.18 #DIV/0! 050F0OLA 37.75 #DIV/0! 050S0F1 43.20 #DIV/0! 060S0A1 9.08 #DIV/0! 060S0F1 0.00 #DIV/0! 164S0B1 6.00 #DIV/0! 17F0DO 3.25 #DIV/0! 226F0DO #DIV/0! #DIV/0! Thank you in advance. . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel function help facilities | Excel Discussion (Misc queries) | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| change function variable prompts?? | Excel Worksheet Functions | |||
| Counting Function Dilemma | Excel Worksheet Functions | |||
| need to save values from a function before it changes | Excel Worksheet Functions | |||
Hybrid Mode
