If I have the following items I want to rank:

untitled.JPG

Right now, I have it where 98.95% is ranked 10th because of the 9 #1 spots ahead of it. How do I make it where 98.95% will be ranked 2nd? Here's an example of my formula in one of the cells: =IF(G99>1,1,RANK(G99,G$99:G$114,0))

Thanks,
Jane