# Need a formula to find difference between values in adjacent cells

This is a discussion on Need a formula to find difference between values in adjacent cells within the Excel Questions forums, part of the Question Forums category; Hi, Hope you can help me. This is probably very easy and irritating question but I cannot remember how to ...

1. ## Need a formula to find difference between values in adjacent cells

Hi, Hope you can help me. This is probably very easy and irritating question but I cannot remember how to find the difference between two values in adjacent columns.

I have two sets of figures and I need to have in the third column the difference in numbers, such as (a1) and (b1). A1 has a figure of say 1086 and B1 has a figure of 796 which would be easy if all the figures in column A were going to be the biggest, I would just subtract b from a but they may change next month to a being 695 and b 1123.

Hope you don't mind me asking this question guys as I have completely forgotten how.

Thanks in advance anyway and will see you again soon no doubt

2. ## Re: Need a formula to find difference between values in adjacent cells

Originally Posted by Crissy
Hi, Hope you can help me. This is probably very easy and irritating question but I cannot remember how to find the difference between two values in adjacent columns.

I have two sets of figures and I need to have in the third column the difference in numbers, such as (a1) and (b1). A1 has a figure of say 1086 and B1 has a figure of 796 which would be easy if all the figures in column A were going to be the biggest, I would just subtract b from a but they may change next month to a being 695 and b 1123.

Hope you don't mind me asking this question guys as I have completely forgotten how.

Thanks in advance anyway and will see you again soon no doubt
Maybe this...

=ABS(A1-B1)

3. ## Re: Need a formula to find difference between values in adjacent cells

Thank you so much T. Valko. Could not remember what I had used before, you have save me a lot of work trying to figure out what I had to do. So simple, I may have been thinking about some other formula.

Thank you

4. ## Re: Need a formula to find difference between values in adjacent cells

Originally Posted by Crissy
Thank you so much T. Valko. Could not remember what I had used before, you have save me a lot of work trying to figure out what I had to do. So simple, I may have been thinking about some other formula.

Thank you
You're welcome. Thanks for the feedback!

5. ## Re: Need a formula to find difference between values in adjacent cells

Hi T. Valko,

You will be pleased to know that I managed to put a conditional format on my work on my own, my god my old brain is working. Need to spend more time watching the mrexcel videos I think to kick start my brain into working.

thanks again

6. ## Re: Need a formula to find difference between values in adjacent cells

Originally Posted by Crissy
Hi T. Valko,

You will be pleased to know that I managed to put a conditional format on my work on my own, my god my old brain is working. Need to spend more time watching the mrexcel videos I think to kick start my brain into working.

thanks again
Good deal!

Excel will keep your brain working, that's for sure!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•