[Gllug] OpenOffice Spreadsheet Formulas - easy question.

[Richard Jones]

On Tue, Feb 02, 2010 at 04:32:23PM +0000, Henry Gilbert wrote:
> Hi All,
> 
> I am stuck on some possibly "dead simple" - for someone that has some
> experience with this, that is.
> 
> I know how to reference cells in absolute terms - for example:
> 
> ACTIVE CELL = C132 + D132
> 
> But I don't know how to do it "relatively" - for example:
> 
> ACTIVE CELL =
> (VALUE OF CELL (ON SAME ROW, BUT 2 COLUMNS to the LEFT))
> +
> (VALUE OF CELL (ON SAME ROW, BUT 1 COLUMN to the LEFT))
> 
> Any clues?

Those are already relative cell references, in the sense that
copy and pasting them will change the reference.

eg in simple terms, if cell B2 contains the reference "A1", then when
B2 is copied and pasted into B3, the reference is updated to "A2".

If you don't want that behaviour [absolute cell reference], then
prefix either the letter or the number (or usually both) with a dollar
sign, so $A$1 stays as $A$1 even when being copied and pasted around.

Rich.

ObComment: People use spreadsheets...?  They have to be the most
annoying way to calculate ever invented.

-- 
Richard Jones
Red Hat
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug