Formula?

[Pam]

I'm trying to add a formula in a cell which will leave
the cell blank if column A is blank. I use the following:

ActiveCell.FormulaR1C1 = "=if(+RC[-10]>0,2.5,"")"


but I get a run-time error (1004). I know the problem is
the quotes in the third argument. I tried replacing the
quotes with zero and it enters zero correctly with no
error. But I need the cell to be blank, not zero, if
column A is blank.

 

[Harald Staff]

Hi
Try four quotes instead of two:
"=if(+RC[-10]>0,2.5,"""")"