Use the array formula:

=MIN(IF(B1:B6<-273,B1:B6))

enter it with CNTRL-SHFT-ENTER instead of ENTER
--
Gary''s Student - gsnu200771


"kazoo" wrote:

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!