try
=if(isna(yourformula),"NO",yourformula)

--
Don Guillett
SalesAid Software

"Freddo" wrote in message
...
If excel returns #N/A due to information not being found for formula, can
it
be changed to No