Tyro,

It didn't work. It came back with "#Name?"

"Tyro" wrote:

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

Tyro


"PAL" wrote in message
...
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.