R1C1 If then Formula

[eazy899]

Hi,

I am using the following R1C1 formulas to enter a formula into a given cell.
This works.

However, I need to use an if then statement within it an for some reason I am unable to do so.

It should say : Formula R1C1 = "if(isblank(RC[1]),"",+RC[1]&"" ""&ROW()"

Can someone help make this work please??

Please Login or Register  to view this content.

[ikboy]

try this:

Please Login or Register  to view this content.

[eazy899]

try this:

Please Login or Register  to view this content.

This is perfect . Thank you.