=MIN(IF(A1:A6<-273,A1:A6))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

Note that you cannot use a whole column in array formulae (prior to excel
2007), but must use an explicit range.

But maybe you really want

=MIN(IF(A1:A60,A1:A6))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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!