+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Registered User
    Join Date
    04-10-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    8

    calculate difference.

    Hi,

    I have two columns...

    A B
    2 4
    6 7
    8 5

    and so on.

    What I wanted to do is have a column C in which I calculate automatically the difference of A and B...how do I write this formula and implement on C ??

  2. #2
    Forum Guru sweep's Avatar
    Join Date
    04-03-2007
    Location
    Location: Location:
    MS-Off Ver
    XL2003 / 2007
    Posts
    2,448

    Re: calculate difference.

    Hi,

    Presuming your data starts in cell A1, enter in C1

    =B1-A1

    and press enter

    Copy this cell and paste it along side all your data.
    Sarcasm - because beating the **** out of someone is illegal.

  3. #3
    Registered User
    Join Date
    04-10-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: calculate difference.

    Thank you...it worked ..

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0