Hi

I have a problem to get the min value from a range

Col C
0.0097
0.02291
0
0.05416

The values can be in negative.

I need to exclude zero when try to get the min value. In this case, 0.0097.
But my formula give the result as 1

=min(($C$1:$C$4)<0)

I think this formula is giving me true/false instead of return the min value.


Would appreciate your assist.

kk