Runtime Error 1004

[angel_03]

hi,

i have programmed the formula below formula for my reports..however i get an error msg which says

"Runtime Error 1004: Application or object defined error"

Range("L276").formula = "=IF(H276<M276,((H276*$J$3)+(M276*(12-$J$3)))/12,((H276*$J$3)+(H276*(12-$J$3)))/12"

i have also defined my worksheet that should be called...

what could be my mistake?

 

[Richard Schollar]

Hi

By the looks of it, your formula has been truncated - quite possibly because you used a < sign in the message (these get interpreted as html unless you use a space after them eg:

"=IF(H37< A38,1,0)"

 

[angel_03]

Hi

By the looks of it, your formula has been truncated - quite possibly because you used a < sign in the message (these get interpreted as html unless you use a space after them eg:

"=IF(H37< A38,1,0)"

"=IF(H530 < M530,((H530*$J$3)+(M530*(12-J3)))/12,((H530*$J$3)+
(H530*(12-J3)))/12"

i have tried that too...but i have another formula which contains a similar statement in my codes, however only this gives out an error msg...

have tried changing the signs but it gives mt the same error

 

[Richard Schollar]

You look like you might be missing a ) off of the end:

"=IF(H530 < M530,((H530*$J$3)+(M530*(12-J3)))/12,((H530*$J$3)+
(H530*(12-J3)))/12)"