Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Nov 2003
    Location
    Tampa, Florida, USA
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Diagonal Calculation in Excel (Excel 2003)

    I have a list of data in Column A that I need to have the first number subtract the second number and put the result in Cell (B2) Then have the second number subtract the third number and put the result in Cell (C3). Then have the third number subtract the fourth number and put the result in Cell D4. Add so on and so on until all of the data is calculated Then fill all of the cells up to the top row-1 with the result from each Cell.
    attached is an example
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Diagonal Calculation in Excel (Excel 2003)

    You could enter this formula in B2:
    <code>
    =IF(ROW()=COLUMN(),$A2-$A3,IF(ROW()>COLUMN(),"",B3))
    </code>
    Fill down to B61, then fill right to column BI.

  3. #3
    Star Lounger
    Join Date
    Nov 2003
    Location
    Tampa, Florida, USA
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Diagonal Calculation in Excel (Excel 2003)

    Hans:
    Tried the formula , filled down and to the right. The formula only calculated a result in Cell B2?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Diagonal Calculation in Excel (Excel 2003)

    See attachment.
    Attached Files Attached Files

  5. #5
    Star Lounger
    Join Date
    Nov 2003
    Location
    Tampa, Florida, USA
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Diagonal Calculation in Excel (Excel 2003)

    Thanks Hans

Posting Permissions

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