View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
mg[_3_] mg[_3_] is offline
external usenet poster
 
Posts: 6
Default #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)
<<------------------------------------------------------