Formula to ignore 0

[bluenose5709]

Hi,

I wonder if anyone may help with the following formula:

=IF(AM22="","",RANK.EQ(AM22,BlueTeam_TotalPts))

This formula works as it should, it is identifying who has the most points in the list, and orders them, 1st 2nd 3rd etc etc... however, as you can see from the screenshot below it is recognising the formula in colum AM and the 0 entry and continuing the formula.

can someone advice how I can get the formula to ignore a 0 entry

 

[Joe4]

How about:

=IF(OR(AM22="",AM22=0),"",RANK.EQ(AM22,BlueTeam_TotalPts))

 

[bluenose5709]

Joe4,

Perfect,

thank you

 

[Joe4]

You are welcome.
Glad I was able to help!