CODEWITHSUNDEEP
excel
sgrtm
sgrtm

Reputation: 15

How to subtract value from the result of previous calculation

it's kinda basic, but I don't even know how to formulate problem correctly. So please kindly help.

The task is:
I have a starting value A1 and a step value B1.
I subtract B1 from A1 and put a value into A2.
This is done by 

=sum(A1-B1)

But then I need to subtract B1 from the result in A2 and so on.
That can be done by 

=sum(A2-B1)

I wonder, what is the way to write a self adjusting formula or, at least, how such functionality would be called, so I can learn it myself.

Upvotes: 1

Views: 1522

Answers (2)

lc.
lc.

Reputation: 116498

You can use absolute addressing to "lock in" the address B1 by prepending the row/column with a $:

=A2-$B$1

This will allow you to copy the formula across; Excel will automatically update the A2 portion but keep the $B$1 constant.

In this case, it looks like you're copying down, an absolute row is most likely what you want (i.e. =A2-B$1)

P.S. You know you're not SUMming anything here, right?

Upvotes: 1

Davesexcel
Davesexcel

Reputation: 6984

You want to make B1 absolute.

In A2 enter this formula

=A1-$B$1

Then drag the formula down.

Upvotes: 1

Related Questions