min value not zero
 

I am looking for a way to evaluate three columns of values to find the one
that is the minimum and not zero. for example:
ColA colB ColC
2.5 3.2 0

The formula should return 2.5.

Any help would be appreciated.

JRForm.

min value not zero
 

Use one of these arrary formulas, depending if you want to allow for negative
numbers or not:

=MIN(IF(A1:C10,A1:C1))

=MIN(IF(A1:C1<0,A1:C1))

NOTE: Array formulas must be entered with CTRL-SHIFT-ENTER instead of just
Enter. If done properly, the formula will be enclosed in { }.

HTH,
Elkar

"JRForm" wrote:

I am looking for a way to evaluate three columns of values to find the one
that is the minimum and not zero. for example:
ColA colB ColC
2.5 3.2 0

The formula should return 2.5.

Any help would be appreciated.

JRForm.

min value not zero
 

Elkar,

Thank you

"Elkar" wrote:

Use one of these arrary formulas, depending if you want to allow for negative
numbers or not:

=MIN(IF(A1:C10,A1:C1))

=MIN(IF(A1:C1<0,A1:C1))

NOTE: Array formulas must be entered with CTRL-SHIFT-ENTER instead of just
Enter. If done properly, the formula will be enclosed in { }.

HTH,
Elkar

"JRForm" wrote:

I am looking for a way to evaluate three columns of values to find the one
that is the minimum and not zero. for example:
ColA colB ColC
2.5 3.2 0

The formula should return 2.5.

Any help would be appreciated.

JRForm.