IF statement with a MIN function

[mach3]

here's a simple IF statement with a MIN function.

=IF(MIN(D$3:D$27)=0,0,MIN(D$3:D$27)-2%)

how do i modify the formula so that:

if the formula returns the MIN value of 0, i want the MIN value greater than zero (in other words, how do i ignore a MIN value of zero?!?). thanks.



mach3

 

[Dave Patton]

On 2002-08-26 08:35, mach3 wrote:
here's a simple IF statement with a MIN function.

=IF(MIN(D$3:D$27)=0,0,MIN(D$3:D$27)-2%)

how do i modify the formula so that:

if the formula returns the MIN value of 0, i want the MIN value greater than zero (in other words, how do i ignore a MIN value of zero?!?). thanks.



mach3

Array enter with Ctrl-Shift-Enter (CSE)

=MIN(IF(D$3:D$27>0,D$3:D$27))*0.98
This message was edited by Dave Patton on 2002-08-26 09:06