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?
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?
Hi!
#VALUE! is the result from a formula. Try this:
=IF(ISERROR(your_formula_here)),"N/A",your_formula_here))
Biff
"Peterpunkin" <[email protected]> wrote in message
news:[email protected]...
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks