Rank Function

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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.

.