Menu
I'm trying to make a complicated formula work using R1C1 notation. During my troubleshooting I can't even make this work in a cell:
=IF(R[0]C[2] = "B", 1, 0)
What am I doing wrong?
301
R1C1 is an absolute reference to the cell at position (1,1) in your Sheet, i.e. A1 in regular notation. The reference with square brackets – R[1]C[1] – is a relative R1C1 reference meaning the cell 1 row down and 1 column to the right of the current cell, wherever that is in your worksheet.
I think may be automatic in a script but in a Sheet needs to be forced, eg:
=IF(INDIRECT("R[0]C[2]", FALSE) = "B", 1, 0)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
