It may be an error to you, but it's not to Excel. It's just text to Excel.
Using:

=if(a1="#N/A N.A.","Price Not Available",a1)

should work. Copy down for all your prices.

--
Regards,
Fred


wrote in message
ups.com...
Hello,

I have a spreadsheet which returns live market prices. From time to
time I receive an error as the price is no available, the error I
receive is #N/A N.A..

I would like to display a warning message to the users that a price is
in error, I would like to check a range of cells for the #N/A N.A.
error, I have over 100 prices.

I hope someone can let me know the best way to do this?

I have tried ISERR and ISNA but it does not work and returns the
result "FALSE".

Thanks in advance,

Brett