On Thu, 09 Feb 2006 17:24:42 -0600, Randomthots wrote: > Paul_B wrote: > >> Is it possible to write the formula >> >> =(C6/C3)^(1/r) >> >> where r = the value of the current row number in the spreadsheet? >> The r value here will progress sequentially as the row number >> increases. >> >> Thanks, >> Paul > > ROW(reference) > Reference is a cell, an area, or the name of an area. > If you do not indicate a reference, the row number of the cell in which > the formula is entered will be found. OpenOffice.org Calc automatically > sets the reference to the current cell.
Perfect. I didn't see the blank reference function. Thanks very much. Paul -- Using OOo 2.0 on Win XP sp2. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
