POST A QUESTION
"dwolf" wrote:
Formula is in cell A3 which is =A1+A2.
If I don't put any numbers in A1 or A2
cell A3 displays #value! Is there a way
to not have the #value! show in cell A3?
If A1 and A2 are truly empty, =A1+A2 will result in zero.
So I presume you mean that A1 or A2 __appears__ blank because one or both
have a formula of the form IF(condition,"",something), which is resulting in
a null string.
In that case, =SUM(A1,A2) might be the simplest solution. It also tolerates
other text strings, e.g. " "; that is one or more blanks, which should be
avoided anyway.
|