Greater than or equal to

I am trying to find a way to specify a cell (to use in a formula)that contains a number greater than or equal to a specified value.

Hoe can I do this?

=INDEX(A1:A10,MIN(IF(A1:A10>=test_value,ROW(A1:A10))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"xned" <xned.25o8om_1144039200.9081@excelforum-nospam.com> wrote in message
news:xned.25o8om_1144039200.9081@excelforum-nospam.com...
>
> I am trying to find a way to specify a cell (to use in a formula)that
> contains a number greater than or equal to a specified value.
>
> Hoe can I do this?
>
>
> --
> xned
> ------------------------------------------------------------------------
> xned's Profile:
http://www.excelforum.com/member.php...o&userid=33098
> View this thread: http://www.excelforum.com/showthread...hreadid=529078
>

Moderator: Please mark as Solved Thanks