Hi
try:
cells(2,3).Formula="=if(a3=2,a3,a2)"

--
Regards
Frank Kabel
Frankfurt, Germany
"mircea" schrieb im Newsbeitrag
...
How to insert a formula in a cell with VBA
example : if formula is "=if(a3=2;a3;a2)"
i used
cells(2,3).Formula="=if(a3=2;a3;a2)"

bu i receive an error
Application object ....

if i used "=s4"
everything is ok.