How to use an IF formula in VBA

[lmichaluk]

Hi there - very new to excel and trying to write a macro that will sum the cells above and then will not let the answer exceed a given amount. For example: the "sum macro" would be something like
Sub b8()
Range("b8").Formula = "=b6+b7"
End Sub

The "If" statement would be something like =IF(B8<100.1,B8,100)

So. How do I include the If statement in the macro?
Thanks

 

[lmichaluk]

I don't have any subs named, although when I pasted the info provided and hit "run" (from the ribbon), I get a window up that names the macro "Sheet4.b13" which is the cell in which the macro is placed. Then when I hit "run" on that menu, I get the same "compile" error message. This happens when I manually replace the 1 with an l as well. I do note that when I put the l into my excel sheet, it displays as a 1 - this happens throughout the sheet.
If need be, I will just add several rows to the sheet, and include all the cell numbers (i.e. long hand way of doing the calc)...not terribly elegant, but seems to work.
I apppreciate your help on this.
Cheers
Linda