View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] roniaelm@hotmail.com is offline
external usenet poster
 
Posts: 54
Default 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!