Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.worksheet.functions




Date Formula Problem  Leave date blank if Null
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)) 
#2
Posted to microsoft.public.excel.worksheet.functions




Date Formula Problem  Leave date blank if Null
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)) 
#3
Posted to microsoft.public.excel.worksheet.functions




Date Formula Problem  Leave date blank if Null
Eh!
Disregard that formula! See what happens when you're in a hurry to go to dinner! Biff "T. Valko" wrote in message ... 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)) 
#4
Posted to microsoft.public.excel.worksheet.functions




Date Formula Problem  Leave date blank if Null
Try it like this (array entered):
=IF(SUM((cond1)*(cond2)*(cond3)*(cond4)*(cond5)),M IN(IF((cond1)*(cond2)*(cond3)*(cond4)*(cond5),rng) ),"") Biff "T. Valko" wrote in message ... Eh! Disregard that formula! See what happens when you're in a hurry to go to dinner! Biff "T. Valko" wrote in message ... 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)) 
#5
Posted to microsoft.public.excel.worksheet.functions




Date Formula Problem  Leave date blank if Null
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" wrote: Try it like this (array entered): =IF(SUM((cond1)*(cond2)*(cond3)*(cond4)*(cond5)),M IN(IF((cond1)*(cond2)*(cond3)*(cond4)*(cond5),rng) ),"") Biff "T. Valko" wrote in message ... Eh! Disregard that formula! See what happens when you're in a hurry to go to dinner! Biff "T. Valko" wrote in message ... 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)) 
#6
Posted to microsoft.public.excel.worksheet.functions




Date Formula Problem  Leave date blank if Null
Yeah, I think that was your best option.
Thanks for the feedback! Biff "Gayla" wrote in message ... 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" wrote: Try it like this (array entered): =IF(SUM((cond1)*(cond2)*(cond3)*(cond4)*(cond5)),M IN(IF((cond1)*(cond2)*(cond3)*(cond4)*(cond5),rng) ),"") Biff "T. Valko" wrote in message ... Eh! Disregard that formula! See what happens when you're in a hurry to go to dinner! Biff "T. Valko" wrote in message ... 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)) 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
If Date Null Show Nothing  Excel Worksheet Functions  
COUNTIF says Null = Blank but Blank < Null  Excel Worksheet Functions  
Run formula only if values are enter, otherwise leave blank  Excel Worksheet Functions  
Formula <0 leave cell blank  Excel Discussion (Misc queries)  
Count number of days between dates BUT IF null to current date  Excel Worksheet Functions 