Greater than or equal to

  • Thread starter Thread starter xned
  • Start date Start date
X

xned

I am trying to find a way to specify a cell (to use in a formula)tha
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)
 
Back
Top