Scoring a result in a cell

[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

 

[Yogi]

try this eric
=LOOKUP(A2,{1,6,11,16,21},{1,2,3,4,5})

 

[Don Guillett Excel MVP]

try this eric
=LOOKUP(A2,{1,6,11,16,21},{1,2,3,4,5})

OR

=ROUNDUP(a2/5, 0) * 5/5

 

[alanglloyd]

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?

A3 has =QUOTIENT(A2, 5) + 1

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

Alan Lloyd

 

[Gord Dibben]

Possible? Most likely.

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


Gord Dibben MS Excel MVP