Greater than or equal to

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
 
B

Bob Phillips

=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)
 

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

Excel Need Countifs Formula Help 0
Finding value using greater than, Vlookup, and nested If 2
Greater than, less than, AS WELL AS value=0 5
How do I use "column" function to get the column number of the firstcell matching criteria? 1
need help writing a formula!!! : ) Please I need to write a formulathat will subtract .5 (half an ho 2
Sumproducting counting blanks 4
Greater, equal to or less than question 2
Validation based on the value in another cell 7

Top