View Single Post
  #1   Report Post  
JSA
 
Posts: n/a
Default Copying a formula and changing ONE value...

I have a formula that needs to be in litterally hundreds of cells on a
worksheet. The formula is:

=SUM(E23/((E18/E17)*(1-A25)))

The thing is, the formula needs to differ on every cell, but only in one
place; the "A25" cell needs to change, like so:

=SUM(E23/((E18/E17)*(1-A25)))
=SUM(E23/((E18/E17)*(1-A26)))
=SUM(E23/((E18/E17)*(1-A27)))

Is it possible to do this easily?