Date Formula Problem - Leave date blank if Null

[Guest]

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=$A15)*
(report!$B$2:$B$3001>0),report!$B$2:$B$3001))

 

[T. Valko]

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((cond1)*(cond2)*(cond3)*(cond4)*(cond5)*rng),"")

Conditional Format:

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

Biff

 

[T. Valko]

Eh!

Disregard that formula! See what happens when you're in a hurry to go to
dinner!

Biff

 

[T. Valko]

Try it like this (array entered):

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

Biff

 

[Guest]

Thanks for the info. I used your first suggestions about the conditional
formatting. I did not think of that. So I just used the option if cell
value =0 then I formatted the font color to match the cell background and it
works great!
Thanks again.

 

[T. Valko]

Yeah, I think that was your best option.

Thanks for the feedback!

Biff