| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
=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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Ignoring charachter data with Product function | Excel Worksheet Functions | |||
| how can i get the slope function to ignore missing data? | Excel Discussion (Misc queries) | |||
| What function or formula do I use to calculate ROI with this data? | Excel Worksheet Functions | |||
Linear Mode
