- Non incremental cell reference
Imagine you have a constant in cell A1 and want to reference this cell in a table and automaticly expand the formula to adjacent cells. By default the A1 cell will be iterated but you can fix it using the dollar sign ($), formula example:
=$A$1 * B1
you can also use the $ to fix the Columns and Lines independently (ie.: $A1 or A$1)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment