Numerically Rank High to low positives then low to high negatives

Hi, I'm trying to figure out a formula for a table that will give me a numerical rank from high to low if the value is positive, then low to high if negative.

E.g.


Value Desired rank
100 2
-50 6
-400 4
60 3
210 1
-70 5

Any thoughts?