<div>
Enter this in B2 and copy down<br />
<br />
=LOG10(A2)/LOG10(5)*1000
</div>


Enter this in B2 and copy down

=LOG10(A2)/LOG10(5)*1000

<div>
Thanks Saqib. &nbsp;I need the difference in values to reduce as the ratings reduce.<br />
eg 5 - 1000<br />
&nbsp; &nbsp; &nbsp;4 - 569<br />
&nbsp; &nbsp; &nbsp;3 - 317<br />
&nbsp; &nbsp; &nbsp;2 - 138<br />
&nbsp; &nbsp; &nbsp;1 - 0
</div>


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

<div>
Thanks for the quick response
</div>


<div>
<div class="content wysiwyg-content">
I need a simple excel tool to help develop rating system values based on logarithmic function.<br />
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.<br />
Thanks
</div>
</div>


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

Excel formulas to calculate logrithmic values

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.