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