using this formula, how do you get it to show the lowest positive number????

"Harlan Grove" wrote:

"Aladin Akyurek" wrote...
Harlan Grove wrote:
....
=IF(A655360,A65536,LOOKUP(2,(A1:INDEX(A1:A65535 ,
MATCH(9.99999999999999E307,A1:A65535))^-0.5)^-2

The idea is worth considering. That is, replacing 1/x with x^-0.5. Is
the formula complete as posted?

Um, no. Not correct. Try this instead.

=IF(A655360,A65536,LOOKUP(2,(A1:INDEX(A1:A65535,
MATCH(9.99999999999999E307,A1:A65535)))^-0.5)^-2)