Formula

G

garima

I have some data in column A : 100, 102, 105, 110
I have data in cell B1 : 103

I want to check whether value 103 comes in range 100, 102, 105, 110.

Here in the given case it has come as value 105 appears which include
103.

I need a formula to check when value 103 arrives or arrived in tha
range. in given case it arrived at 105.

Please help me.

Thank
 
F

Frank Kabel

Hi
not quite sure but maybe
=IF(AND(B1>=MIN(A1:A10),B1<=MAX(A1:A10)),"within range","out of range")
 
Top