How to incorporate into F1C1 Formula with IF Statement RC[n] value?

[dilshod_k]

Hello everyone.

Given: Range("P2").FormulaR1C1 = "=IF ( AND ( RC [-7 ] > RC [-6], R [1] C [-7] < R [1] C [-6]) ,""Text message"", """") )

I've been trying to insert value (Number) of the cell RC[-6] (from the same Row) instead of "Text message" but I could not succeed and I don't even know if it is possible

Would be grateful for any suggestions.
Thanks in advance.

Dil

 

[Fluff]

How about

Range("P2").FormulaR1C1 = "=IF ( AND ( RC [-7 ] > RC [-6], R [1] C [-7] < R [1] C [-6]) ,RC[-6], """")"

 

[dilshod_k]

How about

Range("P2").FormulaR1C1 = "=IF ( AND ( RC [-7 ] > RC [-6], R [1] C [-7] < R [1] C [-6]) ,RC[-6], """")"

Thanks a lot! It was easier then I thought.
My fault was that I've been trying to insert RC[-6] between the quotation marks. ? ?

 

[Fluff]

You're welcome & thanks for the feedback.