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?
|