If range of cells greater than and less than X

[wonderfulsomebody123]

=IF(A2:A11>=50&A2:A11<=59,"*","")

The formula above gives me "#VALUE!"

I am trying to get a "*" if A2:A11 have any number that is in the range between 50-59.

So, if A6 (or any other cell) has 50 (or any other number up to 59), as shown below, I would get a "*" as a sign.

Please help, thank you!

2
26
17
12
50
3
2
4
11
1

 

[kevin9999]

One possibility

Book1
	A	B	C
1	Header		*
2	2
3	26
4	17
5	12
6	50
7	3
8	2
9	4
10	11
11	1
Sheet1

Cell Formulas
Range	Formula
C1	C1	=IF(COUNTIFS($A$2:$A$11,">=50",$A$2:$A$11,"<=59")>0,"*","")