EXCEL function to check a cell is within a range...

[PravinKumarRaja]

Dear friends,

Is there an EXCEL function to check a cell is a subset of a given range (something like Application.Intersect(MyCell, MyRange) Is nothing)? I know that I can as well define a user defined function:

Please Login or Register  to view this content.

Thanks and regards,

Pravin Kumar.

[mehmetcik]

If you are talking about a single cell.

Then if that cell intersects your second range then the cell is in that range.

So

Please Login or Register  to view this content.

You were right. These also works

Please Login or Register  to view this content.

[PravinKumarRaja]

My query is whether there exist an EXCEL function doing the same job.

[mehmetcik]

=IF(ISERROR(D10 D10:M10),"False","True")

D10 is your cell.
D10:M10 is you range

[PravinKumarRaja]

Does ISERROR return TRUE or FALSE depending on the first argument in the second argument? However, the formula does not work.

Thanks for your suggestion all the same.

Pravin Kumar.

[Pepe Le Mokko]

Like

Please Login or Register  to view this content.