I have the following R1C1 line of code that keeps returning an error specifically for this portion
R8C=""FO"",R55C2+R20C
R8C contains FO
R55C2 contains a value of 20
R20C contains a value of -3
The remainder of the code works fine its just this portion
Thank You
Code: Select all
=If(R8C="""",0,If(R8C=""F"",If(R8C=""FO"",R55C2+R20C,R20C2+R20C),HLOOKUP(R8C,R336C7:R367C58,8,FALSE)))