CODEWITHSUNDEEP
excel
Tsukasa
Tsukasa

Reputation: 6552

subtract 2 cells from each row in excel

Looking for a way to subtract 2 different cells in every row. How would I make a formula. I have tried the following

=G&ROW()-B&ROW()

Upvotes: 0

Views: 7252

Answers (2)

user2140173
user2140173

Reputation:

enter image description here

If you click the tiny black square at the right-bottom of the selected cell and drag the formula down it will copy it automatically increasing row numbers.

Upvotes: 1

Sam
Sam

Reputation: 7303

You can use 

=G1-B1

in row 1, when you drag it Excel will automatically adjust it for you.

If you don't want Excel to change the range when you adjust, you should use $

=$G$1-$B$1

If you just wanted to adjust the row but keep the column static you can use

=$G1-$B1

etc.

Upvotes: 1

Related Questions