Rank Percentage Shown 0%

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

 

[Max]

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

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.

 

[Guest]

Yes, it work! TQ

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.

 

[Max]

Pleasure' Param !
Glad it worked ..