Make sure you include the equals sign in the formula property, just like a regular formula.. "=C2+C3

----- bruce forster wrote: ----

I have typed the following code and when executed the formula shows in the cell not the number. What do I do?

Public Sub FormulaTest_Click(
Range("E2").Selec
If Range("A1").Value = "Input" Then Range("F2").Formula = "C2 + C3
If Range("A1").Value = "% of Rev" Then Range("F2").Formula = "C2*.5
End Su

Thanks.