No Ranking

[Salza]

Hi all,

In an exam marksheet, I need to follow this condition.

If the student get a zero mark in any one subject, he won't be ranked in the
class. (or Rank last in the class)
I used the percentage to rank.
How do I do that?

Say ... the mark is in cells D7, F7,H7,J7 and L7.
The percentage is in cell Z7.
Any formula to make cell Z7 shows value 0 if any one of cells D7, F7,H7,J7
or L7 has 0 mark.

Please advise.
Thanks

 

[Dave Peterson]

Maybe you could modify precentage in Z7:
=if(d7*f7*h7*j7*l7=0,0,average(d7,f7,h7,j7,l7))

Then rank that column.