calculate Score by function

G

Guest

what should I have to do if i want to give score 5 at 1000
and with every increase or decrease of 25 in 1000 .25
should be added in 5 or subtracted respectively.

Thanks

Shw
 
F

Frank Kabel

Hi
if your vcalue is in A1 try the following formula
=FLOOR(A1-500,25)/25*0.25

or shorter make this
=FLOOR(A1-500,25)/100
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

function to calculate score 1
how do I use array references in VLOOKUP()? 2
Logical Function 1
Scoring a result in a cell 4
Calculate score from Scale 5
nested "IF" function in Excel 2007 2
Finding Average of last 5 entries 11
Excel 2003 calculation sequence 6

Top