Forum Discussion

Trish2022

Copper Contributor

Dec 15, 2022

Solved

drag to “fill” not working – value is copied, formula ignored

I've tried the calculations tab but it is already on auto and have check in file, options, advanced, handle fill is enabled but I can't drag formula, it drags the original cell number? Any ideas? ...

excel

Formulas and Functions

PeterBartholomew1
Dec 15, 2022
Trish2022
The formula you show is in cell C5 and it is copying. However, since it contains constants, the formula will be identical in every cell and will give identical values. For the formula to change, it must include a relative cell reference, as shown
RelativeReference = -C4 * (1+5%) Array = -$C$4:$G$5 * (1+5%)

Trish2022

Copper Contributor

Dec 15, 2022

thanks for the reply but I'm afraid that doesn't work, cells aren't locked with $

OliverScheurich

Gold Contributor

Dec 15, 2022

Trish2022

Can you add a screenshot without sensitive data that shows what you get when dragging the formula?

Trish2022
Copper Contributor
Dec 15, 2022
OliverScheurich
- PeterBartholomew1
  Silver Contributor
  Dec 15, 2022
  Trish2022
  The formula you show is in cell C5 and it is copying. However, since it contains constants, the formula will be identical in every cell and will give identical values. For the formula to change, it must include a relative cell reference, as shown
  RelativeReference = -C4 * (1+5%) Array = -$C$4:$G$5 * (1+5%)
  - Trish2022
    Copper Contributor
    Dec 15, 2022
    novice error - thank you
- Trish2022
  Copper Contributor
  Dec 15, 2022
  @Quadruple_Pawn it gives three choices: copy cells, fill formatting only, fill without formatting
  - OliverScheurich
    Gold Contributor
    Dec 15, 2022
    Trish2022
    =-2374.41*(1+5%)^COLUMN(A1)
    Do you want to increment the value by 5% ? If so you can try the above formula which includes a dynamic reference.