Richard Detwiler wrote:
[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.
You're right. There is some situation where a zero multiplier causes an
error but I'm too tired to remember it.
So why is the OP getting an error message?
--
Xfce on PCLinuxOS, OOo 2.0.2 (en_GB).
Direct mail to teaman is not opened; if necessary, email realmail.
If you're seeking, check out http://www.rci.org.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
