S
steve
If I have 4 cells, and I want the minimum value greater
than zero of the 4 cells, how do I write this?
Example
A2=3
B2=8
C2=0
D2=9
I want the formula (in cell E2) to return the value 3. If
I use MIN it returns 0. However, the list may have
multiple zero's.
Is there a way to put a constraint so it will return the
lowest value greater than zero?
than zero of the 4 cells, how do I write this?
Example
A2=3
B2=8
C2=0
D2=9
I want the formula (in cell E2) to return the value 3. If
I use MIN it returns 0. However, the list may have
multiple zero's.
Is there a way to put a constraint so it will return the
lowest value greater than zero?
2,COUNTIF(A2