if function with #No Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Preventing a function being called if argument is unchanged 9
Creating DDE link to DDE server in Excel 2007 0
Evaluating a DDE formula created by strings 2
trying to use the index function when #N/A can be part of data ran 5
xlbgnm in remote data 1
Merging Excel Sheet with Excel Sheet (Just like in MS Word!) 3
Arrayformulas with either/or nested to sumproduct if eitherconditions are true 13
Multiple arguments 1

Back
Top