#value! when cell is blank
 

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

#value! when cell is blank
 

One way:

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

another:

A3: =SUM(A1:A2)

since SUM ignores text.

In article .com,
"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

#value! when cell is blank
 

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

=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)
<<------------------------------------------------------

#value! when cell is blank
 

Misread your requirement - use the second of my suggestions...

In article ,
JE McGimpsey wrote:

One way:

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

#value! when cell is blank
 

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



"JE McGimpsey" wrote in message
...
Misread your requirement - use the second of my suggestions...

In article ,
JE McGimpsey wrote:

One way:

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

#value! when cell is blank
 

one way:

=SUM(A1,-N(A2))



In article .com,
"Ryan H." wrote:

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

#value! when cell is blank
 

Hi,


=N(A1)+N(A2)

or

=SUM(A1)+SUM(A2)


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