Novicesportsperformer
New Member
- Joined
- Nov 21, 2016
- Messages
- 37
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
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