Excel formulas to calculate logrithmic values

I need a simple excel tool to help develop rating system values based on logarithmic function.
I have attached an excel file in which the ratings are from 5 to 1, the value of 1000 if for rating 5, and I need to insert formulas to derive values for ratings 2-4.
Thanks
gh_userAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
=1000-LOG10(6-A2)/LOG10(5)*1000
0
 
Saqib Husain, SyedEngineerCommented:
Enter this in B2 and copy down

=LOG10(A2)/LOG10(5)*1000
0
 
gh_userAuthor Commented:
Thanks Saqib.  I need the difference in values to reduce as the ratings reduce.
eg 5 - 1000
     4 - 569
     3 - 317
     2 - 138
     1 - 0
0
 
gh_userAuthor Commented:
Thanks for the quick response
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.