title: Write IF statement using FormulaR1C1 in VBA Excel
body: <p>I have the following formula 
          <code>=IF((GLOBAL_DATE-30)&lt;G2,"1 Month",IF((GLOBAL_DATE-60)&lt;G2,"2 Month",IF((GLOBAL_DATE-90)&lt;G2,"3 Month","Older Than 3 Months")))</code>
  and I would like to write this into specific cells using the FormualR1C1 in VBA.
  (the GLOBAL_DATE is a named cell on another sheet)</p>
  
  <p>Thanks</p>