Page 1 of 1

[Solved] Constants in formulas

PostPosted: Sat May 18, 2019 6:51 pm
by nolac
I am trying to copy and paste formulas in my spreadsheet to other cells. The software adds rows to the original cell locations in the original formula; I would like it to keep the original cell locations. In Excel if I remember correctly, you simply put a '$' before the cell number to achieve this. Can anyone tell me please what the solution is in NeoOffice? Thank you

Re: constants in formulas

PostPosted: Sat May 18, 2019 7:56 pm
by FJCC
I have never used NewOffice but every other spreadsheet I have used uses the $ before both the column and row.
Code: Select all   Expand viewCollapse view
=$C$12

Re: Constants in formulas

PostPosted: Sun May 19, 2019 1:29 am
by robleyd
You might find [Tutorial] Absolute, relative and mixed references useful reading.

Also, see if there is more information on the NeoOffice resources site

Re: Constants in formulas

PostPosted: Tue May 21, 2019 1:01 am
by nolac
Thank you!