I am using Apple Numbers and find it frustrating that cell arguments containing empty text (and sometimes contain numbers from other sheets) are not converted to a number of value 0, when referenced by a function that expects a numeric value.
For example, a function in cell:
with J5 being empty, yields an error message
The operator xe2x80x9c*xe2x80x9d expects a number but found xe2x80x9c.xe2x80x9d
So I tried to encase J5 with VALUE(J5), and got another message:
VALUE requires a string specifying a number, but found xe2x80x9cxe2x80x9d instead.
Is there an efficient way to treat all spaces as 0 for the countless cells that may have that situation?