IF Function Trouble

[Novicesportsperformer]

Hi All,

I think I may need a If function but I'm not totally sure.

Depending on the value in Cell A1 I want to be able to give a score of either 1,2,3 in Cell B1

For example if A1>10 then B1 =3 , If A1 is between 9-5 then B1 = 2, If A1 <5 then B1 = 1

Can This be done?

Cheers

 

[AlanY]

=if(A1<5,1,if(A1<10,2,3))