Forum Discussion
ala6xxxx
May 15, 2020Copper Contributor
Limiting fill values in a formula
In a cell, I have the following formula: =(B2*E1+B2)-G1. I want to autofull by dragging that cell downwards, but I only want the B2's to auto increase, while keeping E1 and G1 the same. For example,...
- May 15, 2020=(B2*$E$1+B2)-$G$1
Then, you drag down using auto fill handle
That will be your formula
Abiola1
May 15, 2020MVP
=(B2*$E$1+B2)-$G$1
Then, you drag down using auto fill handle
That will be your formula
Then, you drag down using auto fill handle
That will be your formula