Error Reporting

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

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

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Freddo" <Freddo@discussions.microsoft.com> wrote in message
news:11AB2D40-BFB6-4B69-824B-BF56A14E0534@microsoft.com...
> If excel returns #N/A due to information not being found for formula, can
> it
> be changed to No