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.

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.

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.