Getting Min Value

[kk]

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

 

[Mangesh Yadav]

Use:

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

and press ctrl + shift + enter

Mangesh




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

 

[kk]

Thank you, Mangesh

It works as I need.



Use:

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

and press ctrl + shift + enter

Mangesh




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

 

[kk]

Thank you, Mangesh

It works as I need.



Use:

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

and press ctrl + shift + enter

Mangesh




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