Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ignoring error values in a formula
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!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ignoring error values in a formula
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 "Nicola" wrote: 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Copy formula with skipping rows | Excel Worksheet Functions | |||
Locking portions of a formula | Excel Worksheet Functions | |||
Ignoring #DIV/0! in a formula | Excel Discussion (Misc queries) | |||
Formula to average ignoring negatives? | Excel Discussion (Misc queries) |