[EMAIL PROTECTED] wrote:
Is this still the problem?
quote:
I want to multiply a row that is sparsely populated with non-zero
numbers only where there are data: when there are no date the cell is
blank. But, when you multiply a blank you get an error message: #value!.
Can you suppress this error message?
:unquote
You get an error whenever zero is multiplied. Zero values as well as
blank cells will produce an error.
This will return an empty string if the referenced cell equals zero:
=IF(A1<>0;A1*10;"")
??
I don't get this behavior. If I have the following formula in B1:
=A1*10
if A1 is blank, B1=0
if A1 is zero, B1=0
if A1=5, B1=50
So for me, neither zero values nor blank cells produce an error.
I may well be understanding things incorrectly, so please correct me if
I'm wrong. But I can't get an error message by multiplying by a zero or
a blank cell.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
