Incremmenting a formula

  • Thread starter Thread starter Patti
  • Start date Start date
P

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.
 
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 ?
 
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
Click to expand...
4. What do you want it to display
 
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.
 
Back
Top