While researching my own formula issues, I came across this thread that I think applies to my situation. However, I can't for the life of me get it to work properly. Formula R1C1 is a foreign concept to me which is probably why I can't seem to wrap my head around it.

I'm trying to insert a formula using VBA and variables. The original formula is...

=IF(DG4<>0,DF4/(DF4+DG4),IF(AND(DG4=0,DF4<>0),1,0))

I need to use variables for the columns because the column where the formula is inserted, initially DH, can change depending on the data. LC will reference the last column used (previously DH) but I'm not sure how to use that in this formula or how to reference the other columns offset to the left, 1 and 2 columns over. Any help would be greatly appreciated!!!