| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN and IF functions return no value if there is no date
Hello,
I am using this array formula to give me the smallest date if two ciretira are matched. It works really well, but for some reason if there is no date in the list it returns the 00-Jan-00 value. Is there a way that it does not return any values at all and the cell remains empty? =MIN(IF(H9:$H20=B5,IF(I9:I20=B9,Timesheet!G9:G20," "))) Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Most functions do not work and return #Name? | Excel Worksheet Functions | |||
| When save as another file, EDATE and XIRR functions return #N/A | Excel Worksheet Functions | |||
| How to return value from functions in other sheets? | Excel Worksheet Functions | |||
| All arithmetic functions return Zero as result | Setting up and Configuration of Excel | |||
| using muliple functions to return one result | Excel Worksheet Functions | |||
Threaded Mode
