Results 1 to 2 of 2

Thread: Adding Cell Value to First Row Only

  1. #1
    Acolyte Tech's Avatar
    Join Date
    Jan 2017
    Posts
    23
    Articles
    0
    Excel Version
    2010

    Adding Cell Value to First Row Only



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    How can I add the value from a cell to the table first row formula only?

    [formula]

    = IF( previousBALANCE=Table1[[#Headers],[BALANCE]], 0, previousBALANCE ) + [@DEPOSIT] - [@PAYMENT]+$J$11

    [/formula]

    J11 is the cell value in question.

    Thanks

  2. #2
    Acolyte Tech's Avatar
    Join Date
    Jan 2017
    Posts
    23
    Articles
    0
    Excel Version
    2010

Posting Permissions

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