I wish to refer to a column of numbers in a formula where a zero is
represented by a blank rather than the number zero in the reference
column. Is there a function which will convert the blank to a zero to
avoid an error?
(e.g.)
the following results in an error in cell B1 so I guess I need a
function which I can use in the formula in B1 which will convert the
blank in A1 to a numeric zero?
CELL A1 CONTAINS blank
CELL A2 CONTAINS 2
CELL B1 CONTAINS =A1+A2


--
Joe Miller
------------------------------------------------------------------------
Joe Miller's Profile: http://www.excelforum.com/member.php...o&userid=29900
View this thread: http://www.excelforum.com/showthread...hreadid=570145