How to reference the <CELL ABOVE>
Is there a way to reference the cell above?
=IF(logical_expression, value_if_true, <CELL ABOVE>)
The simple way is to reference using [COLUMN_NAME]2 (the number being the current row number minus one). But this is broken anytime a row is deleted, which happens frequently on our sheet.
I have tried adding an "index" and "RowNum" column with the formulas; "=1+0", and "=SUM(index$1:index@row)" respectively, then I tried referencing the <CELL ABOVE> with INDEX([COLUMN_NAME]:[COLUMN_NAME], RowNum@row-1) but this returned the "#CIRCULAR REFERENCE" error.
There is a number of ways this can be accomplished in Excel including the OFFSET() and ROW() functions.
Help Article Resources
Check out the Formula Handbook template!