Rank Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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.

.
Click to expand...
 
Back
Top