Find minimum value in a row not zeros

[Dr. Logic]

If i have a row of prices like this:

"120.33" "150.25" "45.00" "" "89.22" ""

how do i return the lowest price without getting a zero because of the blank cells?

=min(a1:f1) is going to return the blank cells as the lowest because they are zero.

Any ideas?

 

[T. Valko]

If i have a row of prices like this:

"120.33" "150.25" "45.00" "" "89.22" ""

how do i return the lowest price without getting a zero because of the blank cells?

=min(a1:f1) is going to return the blank cells as the lowest because they are zero.

Any ideas?

One way...

Assuming the numbers will always be positive numbers.

Array entered**:

=MIN(IF(A1:F1>0,A1:F1))

** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.

 

[Dr. Logic]

Okay, that did it. Thanks!

Array the range for items not equal to zero THEN return the MIN.

My brain is really slow today - thanks for helping.

 

[T. Valko]

Okay, that did it. Thanks!

Array the range for items not equal to zero THEN return the MIN.

My brain is really slow today - thanks for helping.

You're welcome. Thanks for the feedback!