Results 1 to 6 of 6

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. #1
    New Member
    Join Date
    Jan 2012
    Location
    Wales
    Posts
    3

    Question 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. #2
    Board Regular T. Valko's Avatar
    Join Date
    May 2009
    Location
    Pittsburgh
    Posts
    16,133

    Default Re: Need a formula to find difference between values in adjacent cells

    Quote Originally Posted by Crissy View Post
    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)
    .
    Biff
    Microsoft MVP - Excel

    Using Excel 2002, 2007
    KISS - Keep It Simple Stupid

  3. #3
    New Member
    Join Date
    Jan 2012
    Location
    Wales
    Posts
    3

    Smile 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. #4
    Board Regular T. Valko's Avatar
    Join Date
    May 2009
    Location
    Pittsburgh
    Posts
    16,133

    Default Re: Need a formula to find difference between values in adjacent cells

    Quote Originally Posted by Crissy View Post
    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!
    .
    Biff
    Microsoft MVP - Excel

    Using Excel 2002, 2007
    KISS - Keep It Simple Stupid

  5. #5
    New Member
    Join Date
    Jan 2012
    Location
    Wales
    Posts
    3

    Default 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. #6
    Board Regular T. Valko's Avatar
    Join Date
    May 2009
    Location
    Pittsburgh
    Posts
    16,133

    Default Re: Need a formula to find difference between values in adjacent cells

    Quote Originally Posted by Crissy View Post
    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!
    .
    Biff
    Microsoft MVP - Excel

    Using Excel 2002, 2007
    KISS - Keep It Simple Stupid

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com