Formula Help - If Cell Falls Within Certain Range

[jonnyd3388]

Hi! So sorry if a question like this has been posed before, I'm sure it will have been covered at some stage .. I'm looking to create a formula within a work spreadsheet as follows;

If the value of a cell is lower than 5 then new cell is A, if it is between 5 and 9.9 then B, if it is between 10 and 14.9 then C and so on (5 in total).

Thanks for any help!

 

[Toadstool]

Hi!

Here's a couple of methods. The CHOOSE assume no number to check will be 0.000000001 away from the next range (e.g. 4.999999999 is treated as 5).

	A	B	C	D	E	F	G
1	<5	<10	<15	<20	<25	Check	Result
2	22	33	44	55	66	22	66
3
4
5	<5	<10	<15	<20	<25	Check	Result
6	22	33	44	55	66	11	44

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula G2 =IFERROR(CHOOSE(INT(F2/5)+1,A2,B2,C2,D2,E2),"ERROR") G6 =IF(F6<5,A6,IF(F6<10,B6,IF(F6<15,C6,IF(F6<20,D6,IF(F6<25,E6,"ERROR"))))) <tbody> </tbody>

<tbody>
</tbody>

 

[Fluff]

My take on this

Book1
	A	B
1	Score	Grade
2	1	A
3	4	A
4	5	B
5	6	B
6	9	B
7	10	C
8	11	C
9	14	C
10	15	D
11	16	D
12	19	D
13	20	E
14	21	E
15	24	E
16	25
17	26
Test

Cell Formulas
Range	Formula
B2	=LOOKUP(A2,{0,5,10,15,20,25},{"A","B","C","D","E",""})

 

[jonnyd3388]

Thank you guys! These worked brilliantly, really appreciate your help.

 

[Fluff]

Glad we could help & thanks for the feedback