if function with #No Data

D

Diane

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.
 
Top