Replace #VALUE! in cells of a worksheet

[Peterpunkin]

How can I replace the result "#VALUE!" where it occurs in a worksheet with
"N/A"
or else how can I have the cell to the right of any cell bearing N/A also
display N/A?

[Biff]

Hi!

#VALUE! is the result from a formula. Try this:

=IF(ISERROR(your_formula_here)),"N/A",your_formula_here))

Biff

"Peterpunkin" <Peterpunkin@discussions.microsoft.com> wrote in message
news:CA56DAB4-4B31-426A-85C0-06BC1F3C8223@microsoft.com...
> How can I replace the result "#VALUE!" where it occurs in a worksheet with
> "N/A"
> or else how can I have the cell to the right of any cell bearing N/A also
> display N/A?