J
Jarvi
I have the following formula in cell C3
=IF((Calculations!C9-Calculations!C15)=0,"
n/a",Calculations!C3/(Calculations!C9-Calculations!C15))
I wish to copy this to cell C16 but wish to add more than the 13 row
(ie 16 - 3) to each reference in the worksheet Calculations. I need i
to add 27 rows.
The end result formula I need in cell C16 is
=IF((Calculations!C36-Calculations!C42)=0,"
n/a",Calculations!C30/(Calculations!C27-Calculations!C42))
Is there any easy way to do this? Happy to do it using a macro i
necessary. To sum up, I would like to copy a formula and add
constant number of rows to the formula at the same time.
Thanks,
Jame
=IF((Calculations!C9-Calculations!C15)=0,"
n/a",Calculations!C3/(Calculations!C9-Calculations!C15))
I wish to copy this to cell C16 but wish to add more than the 13 row
(ie 16 - 3) to each reference in the worksheet Calculations. I need i
to add 27 rows.
The end result formula I need in cell C16 is
=IF((Calculations!C36-Calculations!C42)=0,"
n/a",Calculations!C30/(Calculations!C27-Calculations!C42))
Is there any easy way to do this? Happy to do it using a macro i
necessary. To sum up, I would like to copy a formula and add
constant number of rows to the formula at the same time.
Thanks,
Jame