[Gllug] OpenOffice Spreadsheet Formulas - easy question.

[Henry Gilbert]

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?

kind regards

Henry


--
SEO Mastery
http://www.alliancetec.com
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug