Hi
Kirk,
To stop formulas from incrementing when you copy and paste, you can use
absolute cell references. An absolute cell reference is a reference to a specific cell that does not change when you copy and paste the formula to other cells.
Here's how you can use absolute cell references in your formula:
- Select the cell with the formula you want to modify.
- Click on the cell reference in the formula that you want to make absolute. In your case, it's cell B2.
- Press the F4 key on your keyboard. This will add dollar signs ($) before the column letter and row number of the cell reference, making it absolute. The cell reference should now look like $B$2.
- Press Enter to save the modified formula.
Now, when you copy and paste the formula to other cells, the cell reference to
B2 will remain absolute and not change.