Incremmenting a formula

[Patti]

How do I get a formula to increase by 12? I can make data
increase by doing a "fill series" but there is not that
option for formulae.

 

[Harald Staff]

If the formula is supposed to figure out and show the sum of two cells, like
=A1+B1
and those cells contain 2, then the formula will display 4. What do you want it to display
after this incrementing operation, and why ?

 

[Guest]

I want to incremment the formula by 12, not the resulting
data. Example: =$C30/$B27 then =$C(30+12)/$B28
I want to be able to drag this across many columns and
have each column refer to a cell that is 12rows from the
one before it.
Patti

-----Original Message-----
If the formula is supposed to figure out and show the sum of two cells, like
=A1+B1
and those cells contain 2, then the formula will display

4. What do you want it to display

 

[Harald Staff]

I see. It's usually done by indirect:
=INDIRECT("C"&29+12*ROW())
but that's using the host cell's absolute row number, so you can't move or change or
insert rows. Pretty vulnerable. If this is a once-for-all-eternity operation then you are
better off with a custom formula-entering macro running once.