#n/a data feeds

[SALO]

In some cells i have some dde links which will return number values when they are updated. until they are updated with a actaul number value though they return #n/a which then messed up other formula on other sheets.

So my question is if in cell A1 I have DDE link that is returning #N/A what Formula can I use in say cell A2 that would just return a zero or nothing.

Any help would be appreciated

 

[Andrew Poulsom]

Try:

=IF(ISNA(A1),"",A1)

 

[SALO]

Great that worked thanks a bundle!