formula change problem

[cparsons]

Dave,

Thanks for the input. I used your example, updated the equations, an
got it to work. Here is what I ended up with. Now my columns can b
anywhere on the spreadsheet and this formula should work.


Code

 

[Dave Peterson]

Glad you got it working.

Dave,

Thanks for the input. I used your example, updated the equations, and
got it to work. Here is what I ended up with. Now my columns can be
anywhere on the spreadsheet and this formula should work.

Code:
--------------------

.Offset(Pay_Row, Paid_COL).FormulaR1C1 = "=IF(RC[" & -1 * (Paid_COL - Pay_Amt_COL) & "]>100, " & _
"IF(RC[" & -1 * (Paid_COL - Pay_Flag_COL) & "]=""Y"", " & _
"IF(RC[" & -1 * (Paid_COL - Country_COL) & "]=""US"",""TRUE"")),""FALSE"")"