+ Reply to Thread
Results 1 to 2 of 2

Setting Up Sums

  1. #1
    Hank Laskin
    Guest

    Setting Up Sums

    I am new at EXCEL.
    I am attempting to setup two columns.
    First column I want to enter amount of an item purchased
    Second column I want to start with a balance and as I enter amounts
    purchased in the first column I would like the balance column to reduce as I
    progressively enter amounts in the first column.

    As an example:
    Amount Column& first entry $5.00
    Balance Column Starting Balance $250.00
    After I insert the $5.00, I would like the second column under the $250 to
    show $245

    --
    Thank you in advance for your assistance
    HankL



  2. #2
    Pete_UK
    Guest

    Re: Setting Up Sums

    Assume your opening balance amount is in cell B2, and you enter the
    first payment in cell A3. Enter this formula in cell B3:

    =IF(A3=0,"",B2-A3)

    Format the cell as currency with 0 decimal places, then copy down. As
    there is nothing in the cells in column A then nothing will show in
    column B, but as soon as you put an entry in A4, then B4 will show.

    Hope this helps.

    Pete


+ Reply to Thread

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.6.0 RC 1