R1C1 cell reference in Google Sheets doesn't work for me

Question

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?

Answer 1

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)