Forum Discussion
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? ...
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%)
=SUM(B4:C4)Perhaps you have locked your cell references with the $ sign. You can try the above formula. The difference is shown in the screenshot.
thanks for the reply but I'm afraid that doesn't work, cells aren't locked with $
Can you add a screenshot without sensitive data that shows what you get when dragging the formula?
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%)