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%)
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%)
- novice error - thank you