Finding the min number

[ryan.fitzpatrick3]

I have 4 columns, a,b,c,d. In a,b,c are 3 separate supplier quotes.
And column d I want this to find the lowest price that is not 0. so
it'll look like this.

example 1

A B C D (lowest)
$2.12 $2.45 $1.98 $1.98

example 2

A B C D (lowest)
$2.12 $0.00 $1.98 $1.98 not $0.00

I normally would just use MIN() but it brings in 0.00, which I don't
want. What should I use?

Ryan

 

[Gary''s Student]

=MIN(IF(A1:C1<>0,A1:C1,""))
This is an array formula that must be entered with CNTRL-SHFT-ENTER rather
than just the ENTER key.

 

[Bob Phillips]

Try this array formula

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

commit with Ctrl-Shift-Enter, not just Enter.

 

[ryan.fitzpatrick3]

Thanks this works, but one more issue, for simplicity I made the
columns A,B,C but actually there are column spaces in between these so
it'll look like this.

A B C D E F
$2.26 $1.99 $2.35

B,D,F have volumes in it, will the arrary work with A1,C1,E1 instead
of A1:C1:?