I have 5000 rows.
Column A is a Product Name
Column B is View volume for the product (from 25,000 to 60)
Column C is a sales rate for the product (from 100% to 2%)

What I'm trying to accomplish is to add a 'score' or index rank to Column D. It should indicate, for the volume of views this product gets, this is an highly or poorly rated score. The score is not binary (good/poor), but a number to rank upon.

I've tried combinations of RANK, STDEV, SUMPRODUCT, etc without success.

Any help welcomed. Thanks!