Thread: Finding the earliest date from a range of cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
squenson via OfficeKB.com squenson via OfficeKB.com is offline
external usenet poster
  
Posts: 78
Default Finding the earliest date from a range of cells
You can test the presence of an error by using the function ISERR which
returns TRUE if there is an error. So the formula could be:
=IF(ISERR(A1:A3), "Put here text in case of error or simply two double
quotes",Min(A1:A3))

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200707/1

Reply With QuoteReply With Quote