Help with an R1C1 reference in a function

[Ben72]

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 figure out what is wrong. It seems simple enough, but, I'm not the brightest bulb on the string, so, your help is very welcome.

[#2]

@Ben72 

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

[#3 · Accepted solution]

@Sergei Baklan ,

I certainly did not. Thank you for your help!

[#4]

@Ben72 , you are welcome