Ignoring error values in a formula

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

Guest

Hi, please help I need to add 2 cells together but in some cases there is an
error (#N/A) value in one of cells. How can I ignore the #N/A but still
return the value of the other cell? Everything I've tried returns the value
#N/A. Please help!!
 
Hi, There is a function to check if a result is #N/A (value not available) so
for example cell a1 can be checked from another cell by:

=if(isna(a1),0,a1)

the zero being returned if a1 is a #N/A

Anthony
 
You must log in or register to reply here.

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

Scrabble Value calculation for Welsh words 0
Set add function ignore #N/A 1
ISERROR on VLOOKUP 3
match formula 2
Sum ignoring cells with error 1
calculate average from non contiguous column, ignoring (0) values 3
How can I automatically replace the error #N/A with 0 in Excel? 3
Lookup or Reference function ignoring errors 2

Back
Top