• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Score

D

dchatrie

New Member
I am trying to assign scores to a project, but i want it to be done automnatically based on the cost, however the issue is I want the largest cost to be assigned the lowest score. Can anyone assist me with a formula. Thank you
 
Hi Michelle ,


You can use the RANK function with the third parameter as 0 ; thus


=RANK(value,range,1)


will assign the highest value the lowest rank


=RANK(value,range,0)


will assign the highest value the highest rank.


Narayan
 
Thanks, but i wanted the scores to reflect as % of the cost. I used this to find the score: (Cost/MAX($C$5:$C$8))*100. which resulted in the obvious of the largest cost having the largest score. Qant a formula to inverted that.
 
In case you were still looking for a response...

If you need the scores to be a % of the maximum cost, then naturally the largest cost would get the maximum score. As such, you may want to reconsider your question in your second post.
 
You must log in or register to reply here.
Back
Top