How do you reference the cell address of the formula you are creating?
For instance, I want to make a calculation in a certain cell based on a value in the cell to the left.
Both of the following produce an error:
=OFFSET(CELL("address"),0,-1)
=OFFSET(ADDRESS(ROW(),COLUMN()),0,-1)
I think...