View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PAL PAL is offline
external usenet poster
 
Posts: 200
Default Time for IFERROR?

I am calculating the time between two dates. In the formula, I account for
the dates being reversed by a conditional. Sometimes the data points are
"N/A" if there shouldn't be a date. The formula below returns a "#VALUE!"
error. Is there a way using IFERROR to return a blank?

=IF((('Raw Data'!F3-'Raw Data'!E3)/$J$1)0,('Raw Data'!F3-'Raw
Data'!E3)/$J$1,"")

Thanks.