if function with #No Data
 

I use a dde link in my Excel spreadsheet. It occasionally returns #No Data.
I use that cell in other functions in my spreadsheet.

I'd like to write a formula (possibly an if function?) so that zero is the
result if the dde link returns "#No Data."

Thanks.

=IF(Cell="#No Data",0,Cell)

--

Regards,

Peo Sjoblom

"Diane" wrote in message
...
I use a dde link in my Excel spreadsheet. It occasionally returns #No
Data.
I use that cell in other functions in my spreadsheet.

I'd like to write a formula (possibly an if function?) so that zero is the
result if the dde link returns "#No Data."

Thanks.