Scoring a result in a cell

  • Thread starter Thread starter stickin
  • Start date Start date
S

stickin

I want to create a score based on a value in a given field, for
example if A2 has a value between 0-5 it receives a score of 1 in A3,
6-10 receives a score of 2 in A3, 11-15 gets a score of 3 in A3 and so
on. Is that possible?

Thanks,
Eric
 
I want to create a score based on a value in a given field, for
example if A2 has a value between 0-5 it receives a score of 1 in A3,
6-10 receives a score of 2 in A3, 11-15 gets a score of 3 in A3 and so
on.  Is that possible?
Click to expand...

A3 has =QUOTIENT(A2, 5) + 1

QUOTIENT is the same as DIV, ie it returns the integer division,
ignoring the remainder.

Alan Lloyd
 
Possible? Most likely.

Depends upon the magnitude of "and so on" which means very little to this
reader.


Gord Dibben MS Excel MVP
 
Back
Top