Hours missed gives a score

[gopherc4]

Trying to get a result if I missed 0 hours, I will get a score of 5, if I missed 1 -4 hours, I get a score of 4, if I missed 5 hours, I get a score of 3, etc.

0 Hours Missed 5
1 - 4 Hours Missed 4
4 - 8 Hours Missed 3
8 - 12 Hours Missed 2
12 -16 Hours Missed 1
>16 Hours Missed 0

I have tried a couple of things, but the formulas get way to messy & start to lose cell references.

Any help appreciated.

[jasoncw]

If the number of hours missed is in A1, here is one option:

=LOOKUP(A1,{0,1,5,9,13,17},{5,4,3,2,1,0})

HTH

Jason

[gopherc4]

Thanks works fine

[jasoncw]

Glad it helped. Please mark the thread solved. Thanks.

Jason