Replace #VALUE! in cells of a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup or match function across worksheets ? 5
Problems with worksheets 1
Search range, find value in another col in corresponding row 3
Set chart series endpoint dynamically 0
MAX across worksheet, return text value 8
Excel VBA 1
Scan group of cells and result based on condition 2
Worksheet name variables 3

Back
Top