Excel Formula
 

I have data in column A : 100, 102, 105, 110

I have data in cell B1 : 10

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 includes 103.

I need a formula to check when value 103 arrives or arrived in that range.

In given case it arrived at 105

Please help me

Thank

Excel Formula
 

Hi
see your post in Excel.worksheet.fucntions
P.S.: please don't multipost

--
Regards
Frank Kabel
Frankfurt, Germany


Garima wrote:
I have 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
includes 103.

I need a formula to check when value 103 arrives or arrived in that
range.

In given case it arrived at 105.

Please help me.

Thanks