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