understanding formula entered with vba

[dpaton05]

Could some explain to me in plain english how the second part of this vba code equates to the following formula in excel please?

.Range("I" & .Range("I" & .Rows.Count).End(xlUp).Row).Formula = "=IF(R[0]C[-4]=""*Activities"",0,RC[-1]*0.1)"

equals

I7=IF(E7="*Activities",0,[Price 
ex. GST]*0.1)

 

[James006]

Hi,

RC is a convention for relative reference R for Row and C for Column ...

R[2]C[-4] would mean based on the initial cell : Add 2 Rows and deduct 4 Columns

Hope this clarifies

 

[dpaton05]

thanks

 

[James006]

You are welcome