=IF(ISNA(your_formula()),"No",your_formula))

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Freddo" wrote in message
...
Is there any way you can change #N/A to show anything else eg No