Harold Fuchs wrote:
On Saturday, December 02, 2006 10:05 PM [GMT+1=CET], Nino Pereira
<[EMAIL PROTECTED]> wrote:
<snip>
I think I have found the cause of your problem and it may be a bug in
OOo.
I get your error message if I use "array formulae" as you have done.
In my example I created A1:A12 as sparsely populated. I then defined
B1:B12 as an array and then set it to "=10*(A1:A12)". I get the error.
However, if I define B1 as "=10*A1" and then copy/drag the formula
down to B12 then the error goes away.
To copy/drag, set the first cell in the result row/column as
appropriate and then click in it. You get a little "+" sign in the
bottom right corner of the cell. Click it and, holding the mouse
button down, drag left/right/up/down to the end of the range you need.
Calc will automatically copy the formula, adjusting row/column numbers
as appropriate. So, in my example above, B2 gets set to "=10*A2", B3
to "=10*A3" and so on.
If you want to include in your formula a value from a specific cell,
then use "absolute" cell referencing: $A$1 means absolutely row A, col
1. "A$1" means relative row A, absolute col 1. Relative references get
changed automatically during copy/drag; absolute references don't. So,
for example, if you want to extend the above example by *always*
dividing the result by the contents of C3, you could copy/drag
"=10*A1/$C$3.
Harold Fuchs
London, England
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;"")
--
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]
