# IF statement with a MIN function

#### mach3

##### Board Regular
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

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
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

Replies
15
Views
800
Replies
1
Views
180
Replies
1
Views
203
Replies
12
Views
471
Replies
5
Views
246

Threads
1,221,241
Messages
6,158,727
Members
451,512
Latest member
aimarhu

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back