Formula

  • Thread starter Thread starter garima
  • Start date Start date
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
 
Hi
not quite sure but maybe
=IF(AND(B1>=MIN(A1:A10),B1<=MAX(A1:A10)),"within range","out of range")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formula Question 5
Excel Formula 1
Search a value in particular range 1
Can this be done? 4
Format an entire row when an ID changes 2
Range compariosn - best of 1
Query 1
Concatenate with differents conditions 3

Back
Top