Formula in VBA

[rsrasc]

A1= $100
B1=$50

Formula in C1 =

=IF(A1>=B1,"YES","NO")

I would like to know how the formula can be formulated in a VBA module.

 

[JackDanIce]

Try:

Range("C1").Formula = "=IF(A1>B1,""Yes"",""No"")"

 

[texasalynn]

A1= $100
B1=$50

Formula in C1 =

=IF(A1>=B1,"YES","NO")

I would like to know how the formula can be formulated in a VBA module.

another way is type your formula into a cell, then use the macro record, select the cell with the formula with F2 and then press enter. Stop the macro recorder