VBA IF function error

Question

I want to insert the following formula to a cell

Range("Q12").FormulaR1C1 = "=If(P12>1,1,P12)"

but my output in the cell is below

=WENN('P12'>1;1;'P12')

the problem is it includes ' ' . Please help me to correct this problem

Thanks

Gary's Student · Accepted Answer · 2014-09-05 13:09:01Z

2

Use the non-R1C1 format:

Sub hfdjs()
    Range("Q12").Formula = "=If(P12>1,1,P12)"
End Sub

answered Sep 5, 2014 at 13:09

Gary's Student

96.9k10 gold badges66 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1