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

Use:

=MIN(IF(C1:C4=0,"",C1:C4))

and press ctrl + shift + enter

Mangesh




"kk" <kkchoh @ yahoo dot com wrote in message
...
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

Thank you, Mangesh

It works as I need.



"Mangesh Yadav" wrote in message
...
Use:

=MIN(IF(C1:C4=0,"",C1:C4))

and press ctrl + shift + enter

Mangesh




"kk" <kkchoh @ yahoo dot com wrote in message
...
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

Thank you, Mangesh

It works as I need.



"Mangesh Yadav" wrote in message
...
Use:

=MIN(IF(C1:C4=0,"",C1:C4))

and press ctrl + shift + enter

Mangesh




"kk" <kkchoh @ yahoo dot com wrote in message
...
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