My bet is the OP is talking temperatures so -274 doesn't exist and he's
trying to exclude absolute zero but then maybe not

"Rick Rothstein (MVP - VB)" wrote:

Is there more to your question than your posted? By this I mean, are you
interested in excluding specifically the number -273 (that is, -272 and -274
are OK?), or are you looking to exclude **all** negative values (as your
example could be interpreted as asking), or perhaps something else?

Rick


"kazoo" wrote in message
...
Is it possible to have a formula with a standard Excel function that gives
the
Min value in a column excluding the number -273?

Example:

Col A
Row1 4.3
Row2 5.7
Row3 4.2
Row4 -273
Row5 3.9
Row6 -273

The formula should return a min of 3.9 for A1:A6

Thanks!