#value! when cell is blank

R

Ryan H.

Hi,

Cell A1 contains the number 5
Cell A2 contains ""
Cell A3 contains =A1+A2

A3 returns #VALUE!

How can I make it return 5?

Thanks
 
J

JE McGimpsey

One way:

A3: =IF(COUNT(A1:A2)=2,A1+A2,"")

another:

A3: =SUM(A1:A2)

since SUM ignores text.
 
M

mg

Sun, 08 Aug 2004 19:24:07 GMT, Ryan H. wrote :
Hi,

Cell A1 contains the number 5
Cell A2 contains ""
Cell A3 contains =A1+A2

A3 returns #VALUE!

How can I make it return 5?

Thanks
Click to expand...

=Sum(A1:A2)

--
Winamp 5.03. odtwarza :
Hubtone feat. Zoe Johnston - Red Balloon (R.A.D.I.O. 42 : Music for
LOUNGE-LOVERS finest electronica chillout house nujazz funky beats
radio42)
<<------------------------------------------------------>>
 
R

Ryan H.

Thank you guys for your responses, but there is a problem.



Cell A1 contains the number 5
Cell A2 contains =""
Cell A3 contains =SUM(A1,-A2)

A3 still returns #VALUE!

I think its because you can't have a negative zero
 
S

Soo Cheon Jheong

Hi,


=N(A1)+N(A2)

or

=SUM(A1)+SUM(A2)


--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--
 
Top