Error Reporting

[Freddo]

If excel returns #N/A due to information not being found for formula, can it
be changed to No

 

[Don Guillett]

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