Home > other >  What is the address of cell $C$12 in R1C1 notation?
What is the address of cell $C$12 in R1C1 notation?

Time:06-14

As part of a practice quiz this question was asked and I wrote down R12C3. I was graded incorrect but everywhere I look online it seems I'm correct.

CodePudding user response:

R12C3 would be right, since you can select C12 and switch to R1C1 in Excel => Options => Formulas => R1C1 notation

So if the reference is "A1" then R12C3 would be right.

If the question was meant to be relative to another cell, the notation would be otherwise e.g.: Starting from B3 the R1C1 formula would be R9C1 to reach C12

  • Related