I need to rank the "% of inc" column but I get an error message (#N/A) on the
ones that have 0%. This is the formula I'm using:
=IF(H6=0,"",RANK(H6,$H$5:$H$15)). I've also tried
=IF(G21=0,"0%",(C21-G21)/G21). What would you suggest?

% of inc Rank
-100% 6
0% #N/A
300% 1
-33% 3
-100% 6
0% #N/A
-100% 6
0% #N/A
-50% 5
50% 2
-33% 3