formula code to give a score

[Novicesportsperformer]

Hi All,

I was wondering if you could help me.

I have a value in cell B2 I would like cell C2 to give a score of either 1,2 or 3 depending on cell B2

So, If B2 score was >4.9, C2 = 3

If B2 was Between 4.8 - 4.4, C2 = 2

If B2 was <4.4, C2 = 1

I'm not very good at this so I was wondering if there was an easy solution?

Thank you I really appreciate any help on this!

Cheers

 

[Special-K99]

=lookup(a1,{-1e308,4.4,4.9},{1,2,3})