Advanced cell reference in excel

Question

I would like to reference the cell "n" rows above the current cell, where n is an variable. I tried the "cell" function, but it doesn't allow me to use string as argument as I must pass the reference without double quote in the function.

Answer 1

use the OFFSET function or RANGE.