IF formula HELP!

[BaileeManfro]

Hello! I am stumped on a Formula I can use (or if its even possible) for the following:

IF cells E2:E462 are less than or equal to 24 then enter S
IF cells E2:E462 are greater than 25 but less than or equal to 249 then enter M
IF cells E2:E462 are greater than 250 but less than or equal to 999 then enter L
IF cells E2:E462 are greater than 1000 but less than or equal to 2999 then enter XL

Hopefully this makes sense... thank you for any help!

 

[Fluff]

Hi & welcome to MrExcel.
How about with a lookup table

Fluff.xlsm
	E	F	G	H	I	J	K	L	M
1
2	8	S						24	S
3	100	M						249	M
4	250	L						999	L
5	1000	XL						2999	XL
6
Main

Cell Formulas
Range	Formula
F2:F5	F2	=INDEX($M$2:$M$5,XMATCH(E2,$L$2:$L$5,1))