Question: what is rc 1 in excel?
Answer: I typed the formula in the worksheet as =SUM(A1:A4), why did Excel change it? ... RC[-1] refers to the cell one column to the left: R without a number means same row as the formula, C[-1] without any number means same column. R1C1 refers the cell in the first row and first cell ($A$1): R1 is first row, C1 is first column.