So I have negative values that I'd like to rank, however a while back I was only taught how to rank a range of positive values. Could you help me edit this one so that I can consider it in a negative & positive range together?
=INDEX(IF($C7:$C="",,IFNA(VLOOKUP($BK7:BK*1, {0%, "0"; 0.01%, "1"; 5%, "2"; 10%, "3"; 15%, "4"; 20%, "5"; 25%, "6"; 30%, "7"; 35%, "8"}, 2, 1))))
The column should fill up based on whether I've added a stock ticker or not, and will fill in a rank based on the result in the previous column (which you can see in the formula).
