Forum Discussion

Copper Contributor

Jun 19, 2020

Solved

Help with an R1C1 reference in a function

I am trying to reference the cell immediately to the left of a cell that contains this function: =IF(RC[-1]="value","output", "") or =IF(EQUALS(RC[-1],"value"),"output","") ...and I can't f...

excel

Formulas and Functions

Ben72
Jun 22, 2020
SergeiBaklan ,

I certainly did not. Thank you for your help!

SergeiBaklan

Diamond Contributor

Jun 19, 2020

Ben72

Perhaps you didn't shift on R1C1 reference mode in options

Ben72

Copper Contributor

Jun 22, 2020

SergeiBaklan ,

I certainly did not. Thank you for your help!

SergeiBaklan
Diamond Contributor
Jun 22, 2020
Ben72 , you are welcome