rank + if isna

[bluepenink]

Hello

can someone help me with my logic in my formula

=IF(ISNA(E12),"",Rank(IF(ISNUMBER(E$12:E$75),E12,$E$12:$E$75,0)))

the error im receiving is that, it's too many arguments?

basically, im trying to do a rank, and i over 20 empty cells, which will get populate in future dates, as we input data.

pls help!

 

[Desu Nota from Columbus]

=IF(ISNA(E12),"",Rank(IF(ISNUMBER(E$12:E$75),E12,$E$12:$E$75),0)))

Missing some parenthesis.

Not sure what you are trying to do, could also be:

=IF(ISNA(E12),"",RANK(IF(ISNUMBER(E$12:E$75),E12),$E$12:$E$75,0))

 

[bluepenink]

hello thxs bud

but it appears a simply if(iserror(rank(....works as well. thxs alot!