Cell reference - Nexus Veritas

# Cell reference ## Definition ### [[Nexus - Google Analytics Certificate Course|Google Analytics Certificate]] >[! Definition] >A cell or range of cells in a worksheet typically used in [[Formula|formulas]] and [[Function|function]] > ## Examples ### In a [[Spreadsheet|spreadsheet]] [[Formula|formula]] #### Relative reference example ```spreadsheet =B2-A2 ``` cells being referenced are `B2` and `A2` in this example. #### Absolute reference example ```spreadsheet =$B$2-A2 ``` The above example shows absolute column reference and row reference on the first [[Cell reference]] This means that if this formula was copied / or filled to another cell the reference to `B2` would stay the same. Absolute references are denoted by a `

symbol. ## Related ## Resources ## Flashcards The below code are generated for use with [Spaced Repetition plugin](https://github.com/st3v3nmw/obsidian-spaced-repetition/) [docs](https://www.stephenmwangi.com/obsidian-spaced-repetition/) A cell or range of cells in a worksheet typically used in [[Formula|formulas]] and [[Function|function]] @@@ [[Cell reference]]