Limiting fill values in a formula

[ala6xxxx]

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, instead of =(B3*E2+B3)-G2, then =(B4*E3+B4)-G3, etc., when what I want is =(B3*E1+B3)-G1, then =(B4*E1+B4)-G1 etc. 

[#2 · Accepted solution]

=(B2*$E$1+B2)-$G$1
Then, you drag down using auto fill handle


That will be your formula

[#3]

@ala6xxxx That would be

=(B2*$E$1+B2)-$G$1

Ooops: 2 minutes too late

[#4]

@Abiola1 

Works perfectly. Thanks!

[#5]

Glad to hwlp

So stay safe