Need help with simple formula reminder

[cmisero]

Been so long since I've had to do it, just drawing a blank.Essentially I want a number to generate in a cell that depends on what range of numbers is in a previous cell.
In layman's terms- If A1 is greater than 60% B1 should show a 3. If A1 is between 50 and 60% B1 should show a 2. If A1 is less than 50% B1 should show a 3

Apologies if this is in the wrong section

 

[Fluff]

You have if A1 >60% then 3 & A1<50% then 3. Is that right?
Also will your figures always be positive numbers?

 

[Jeffrey Mahoney]

=IFS(A1>60%,3,AND(A1>=50%,A1<=60%),2,A1<50%,1)
I assumed you wanted a 1 if the value was less than 50%. This assumes you have the latest version of Excel to the IFS function. If not, let me knoiw.

 

[cmisero]

You have if A1 >60% then 3 & A1<50% then 3. Is that right?
Also will your figures always be positive numbers?

Apologies. Typo. If A1 >60% then 3. If A1 is between 50 & 60% then 2 and If A1<50% then 1

All will be positive numbers

 

[Fluff]

Thanks for that.
Another option

=LOOKUP(A1,{0,0.5,0.6},{1,2,3})

 

[cmisero]

=IFS(A1>60%,3,AND(A1>=50%,A1<=60%),2,A1<50%,1)
I assumed you wanted a 1 if the value was less than 50%. This assumes you have the latest version of Excel to the IFS function. If not, let me knoiw.

Exactly what I was looking for. Thanks so much!

 

[smalik]

This can also be done by using the vlookup table:

"true" command in the vlookup formula looks for the closest match before moving to the next range.

To me this is helpful as I can change the criteria in the future if need be. (my 2 cents)