| 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)) |
| 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 | |||
Threaded Mode
