B
boxarox
I have a column of numbers that are the results from formulas. in the absence
of enter values, the results column (say D) show several zeros.
I use =min(d1:d16) placed in column E to return the lowest value in the
colunm D which is ussually zero.
What I want to do is ignore the zeros and pick the lowest numer that is not 0.
=IF(e12<=0,e12,SMALL(d5:d12,2)) works for a column of negative numbers,
because they are all less than zero.
I can't seem to get the formula right For Positive integers.
Help please
of enter values, the results column (say D) show several zeros.
I use =min(d1:d16) placed in column E to return the lowest value in the
colunm D which is ussually zero.
What I want to do is ignore the zeros and pick the lowest numer that is not 0.
=IF(e12<=0,e12,SMALL(d5:d12,2)) works for a column of negative numbers,
because they are all less than zero.
I can't seem to get the formula right For Positive integers.
Help please