Macro Code for formula IF(E2="WORDS", F2,F2*500)

[teki]

I am trying to write a code that allows me to have in the column L the following formula; IF(E2="WORDS", F2,F2*500). And I want it to go until the end of Column E. I am going crazy with many different ways and none work... please help!!!
Much appreciated!!

 

[VoG]

Try like this

LR = Range("E" & Rows.Count).End(xlUp).Row
Range("L2:L" & LR).Formula = "=IF(E2=""WORDS"", F2,F2*500)"

 

[teki]

Thank you SOOOO MUCH!!!!!
I have just started working with Macros... and I did spend all day looking for this... it looks so easy and it works! thanks a lot!