Claudia Drechsle wrote:
So the formula submits to a function a different value than the one you get
directly, is it that?
When you write in A3: =OFFSET(A1;1;0;1;$A$1)
And in A4: =SUM(A3)
That will never be the same than =SUM(OFFSET(A1;1;0;1;$A$1))
Are there more cases like this?
The description in Help says that it "returns the value of a cell", but
this is not correct, as the Function Wizard correctly says, it returns a
reference (to a range - which can one or more cells of course).
In the case of =OFFSET(...), the returned reference is (re)evaluated to
return the cell value, and in the case of =SUM(OFFSET(...)) it is
evaluated by the SUM() function.
The formula =OFFSET(A1;1;0;1;$A$1) is returning the value of the first
cell in the range. The result would be the same if you omitted the last
two parameters. The first parameter is the name of the cell from which
the offset is taken. The next adds one row and the next adds zero
columns. The fourth parameter is the number of rows and the last is the
number of columns.
Claudia Drechsle wrote:
Hi Terry wrote:
Try this: =SUM(OFFSET(A1;1;0;1;$A$1))
I never saw the function offset in this use, that opens new views for me,
its great.
But I do not really understand it.
When I write the function OFFSET(A1;1;0;1;$A$1) alone, it provides a
value, in the actual example it's allways 2.
But SUM(2) would not be, what we look for.
I see, that your formula works, but I don't know why.
Send instant messages to your online friends http://au.messenger.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
