Ask Your Question

#NA - ERROR handle in formula

asked 2019-02-13 15:22:23 +0100

Albireo gravatar image

Assume three columns A, B and C. Columns A and B can contain text, numeric values or #NA.

Column C should summarize the columns A and B

eg If A2=123 and B2=#NA the result in C2=123

or If A2=#NA and B2=K2-123 the result in C2=K2-123

or if A2=#NA and B2=#NAthe result in C2= (empty cell)

or if A2=123 and B2=K2-123 the result in C2=123 (the same as cell A2)

Is it possible to handle #NA in a formula?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-02-13 15:25:36 +0100

Yes. There are ISNA and IFNA functions (that are suggested, e.g., when one writes NA in Function Wizard).

edit flag offensive delete link more


Thanks! It works for me! (but the formula for managing this, did not get small). Is it possible to get the formula IF NOT NA or IS NOT NA?

Albireo gravatar imageAlbireo ( 2019-02-13 21:37:05 +0100 )edit

NOT(ISNA(A2)) or IF(ISNA(A2);...then...;...else...)

erAck gravatar imageerAck ( 2019-02-14 18:59:41 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-13 15:22:23 +0100

Seen: 17 times

Last updated: Feb 13