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