Rank Percentage Shown 0%

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

Guest

Hi,

I created few column to enter students score. At column H (all the marks are converted to percentage). Later I use the following formula below to rank the students. What I can see is, ranking still on although 0.00% are shown. Any way to blank the cell if 0.00% appear.

formula: =IF(H10="","",RANK(H10,$H$10:$H$37))

Thanks.
 
Maybe try: =IF(H10=0,"",RANK(H10,$H$10:$H$37))
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----
Param said:
Hi,

I created few column to enter students score. At column H (all the marks
Click to expand...
are converted to percentage). Later I use the following formula below to
rank the students. What I can see is, ranking still on although 0.00% are
shown. Any way to blank the cell if 0.00% appear.
 
Yes, it work! TQ

Max said:
Maybe try: =IF(H10=0,"",RANK(H10,$H$10:$H$37))
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

are converted to percentage). Later I use the following formula below to
rank the students. What I can see is, ranking still on although 0.00% are
shown. Any way to blank the cell if 0.00% appear.
Click to expand...
 
Back
Top