Getting Min Value

  • Thread starter Thread starter kk
  • Start date Start date
K

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
 
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
 
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
 
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
 
Back
Top