You might be better off using conditional formatting to "hide" the zero. You
could write the blank into the formula but then it'll be twice as long.

=IF((cond1)*(cond2)*(cond3)*(cond4)*(cond5),MIN((c ond1)*(cond2)*(cond3)*(cond4)*(cond5)*rng),"")

Conditional Format:

Select the cell with the formula
Goto FormatConditional Formatting
Formula Is: =cell_ref=0
Set the Font color to be the same as the fill color
Ok out

Biff

"Gayla" wrote in message
...
I have a multiconditional formula which finds the earliest date of all
entries where all these conditions are met. If an entry does not consist
of
all these conditions, I just want the cell left blank. How do I do that?
I
have tried putting ,"" at the end of the formula but it still doesnt work.
Any help will be greatly appreciated.
MIN(IF((report!$D$2:$D$3001=$A$3)*(report!$I$2:$I$ 3001=$A$11)*
(report!$J$2:$J$3001=$A14)*(report!$K$2:$K$3001=$A 15)*
(report!$B$2:$B$30010),report!$B$2:$B$3001))