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

Drop down list control value in vba 2
Force Distribution/ Force Ranking for Bell Curve 1
function to calculate score 1
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Scoring a result in a cell 4
Want To Shrink Formula 1
Music Collection Database 1
Logical Function 1

Top