IF Function as formula not working in VBA

[Janb]

To get the following formula in a cell (example N1912 but it's always the 3rd row below the lastrow)

= if(N1912 > 500, 0, 25)

I'm using the code below. But the result is TRUE instead of 0 when OndergrensOnderwaarde < 500 and 25 when the value >+ 500

OndergrensOnderwaarde = 500.
The value of it is in the .offset(2,13)

.Offset(3, 13).Formula = "=if(" & .Offset(2, 13).Address >= " & OndergrensOrderwaarde  ,0 , 25)"

I've tried a lot of combinations and did a lot of research on Google but can't figure it out.

Can you please help?

 

[Fluff]

Try it like

.Offset(3, 13).Formula = "=if(" & .Offset(2, 13).Address & ">= OndergrensOrderwaarde  ,0 , 25)"

 

[Janb]

Try it like

.Offset(3, 13).Formula = "=if(" & .Offset(2, 13).Address & ">= OndergrensOrderwaarde  ,0 , 25)"

Thank you for your quick answer. I have result but the variable OndergrensWaarde is text instead of a number:

Result:

=IF($N$1922>=@ OndergrensOrderwaarde;0; 25)

 

[Fluff]

As there was no mention of it being a variable I assumed it was a named range.
Try

.Offset(3, 13).Formula = "=if(" & .Offset(2, 13).Address & ">=" & OndergrensOrderwaarde & "  ,0 , 25)"

 

[Janb]

As there was no mention of it being a variable I assumed it was a named range.
Try

.Offset(3, 13).Formula = "=if(" & .Offset(2, 13).Address & ">=" & OndergrensOrderwaarde & "  ,0 , 25)"

Thank you very much! It works.

PS apologize for the variable. I thought that it was clear when I mentioned OndergrensOrderwaarde = 500.

 

[Fluff]

You're welcome & thanks for the feedback.