Formula problem

**nightcrawler-jay** · 07-09-2010, 01:04 AM

Hi,

I am trying to get a formula to assist with, column B needs to be subtracted from column A and the answer then needs to be added to the next value in column A.
A B
1 1000 1500 = ( -500 ) +A2 = 100
2 600 900
3 2600 300

**royUK** · 07-09-2010, 01:10 AM

I can't see the problem
=A1-B1+A2

Copy down

**Trebor76** · 07-09-2010, 01:13 AM

Hi nightcrawler-jay,

Welcome to the forum!!

Try this formula in your desired output cell:

=A1-B1+A2

Regards,

Robert

**nightcrawler-jay** · 07-09-2010, 01:15 AM

Hi Roy.

I get that but how do I get the formula to carry on automatically?

**royUK** · 07-09-2010, 01:17 AM

You just drag it down the column

**nightcrawler-jay** · 07-09-2010, 01:24 AM

Thanks Roy.

That has solved my issue.

**royUK** · 07-09-2010, 01:31 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save