Forum Discussion

ala6xxxx's avatar
ala6xxxx
Copper Contributor
May 15, 2020
Solved

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,...
  • Abiola1's avatar
    May 15, 2020
    =(B2*$E$1+B2)-$G$1
    Then, you drag down using auto fill handle


    That will be your formula

Resources