Forum Discussion
Formula automatically adjusts to grab the next cell below
How do I program a formula to grab the next cell below so that it automatically includes that cell in the formula recalculation. Ex) =SUM(M522+H525)-G525 Where when I insert a new row below with ne...
Can you provide some more information on the formula adjustment? Sharing a sample workbook, without any sensitive data, of what the current formula generates and what the adjusted solution should be will help
If you copy your formula, the cell references will change automatically.
so, if wrote your formula in L522 =SUM(M522+H525)-G525 and you copy the formula to L523, they formula will be =SUM(M523+H526)-G526, this is called absolute references in excel