Bsmile wrote:
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?

try nesting another If statement to place a 0 instead of a #NA.

=IF(ISERROR((C21-G21)/G21),0,(C21-G21)/G21)