formula change problem

C

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
 
D

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"")"
Click to expand...
 
Top