stock remaining..

Discussion in 'Microsoft Excel Worksheet Functions' started by salman.way@gmail.com, Aug 6, 2012.

  1. Guest

    Suppose I have a expense head Internet and have Internet budget say 10000 for a year..
    My sheet shoud work like

    Sno. | Voucher No. | Head | Amount | Budget remaining
    1 | V74 | Internet | 3000 | 7000

    Means when every I put an expense "Budget remaining" column should show me the remaining budget.
     
    , Aug 6, 2012
    #1
    1. Advertisements

  2. zvkmpw Guest

    On Sunday, August 5, 2012 9:50:16 PM UTC-7, Mohammad Salman wrote:
    > Suppose I have a expense head Internet and have Internet budget say 10000 for a year..
    >
    > My sheet shoud work like
    >
    > Sno. | Voucher No. | Head | Amount | Budget remaining
    > 1 | V74 | Internet | 3000 | 7000
    >
    > Means when every I put an expense "Budget remaining" column should show
    > me the remaining budget.


    I'm assuming that the worksheet has only Internet expenses, with other categories elsewhere. If categories are intermixed, it's more complicated, but doable.

    My suggestion is to put the yearly budget of 10000 in E2 under "Budget Remaining." The entry in B2 could say "Starting Balance" or something similar (it's not a voucher).

    The first voucher would be in row 3.

    To calculate the budget remaining in E3, put
    =E2-D3
    Copy this formula down as far as needed for new vouchers.

    Hope this helps getting started.
     
    zvkmpw, Aug 6, 2012
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Don Rountree

    Remaining workdays

    Don Rountree, Oct 16, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    12
    Views:
    327
    Chip Pearson
    Oct 16, 2003
  2. JBE

    Stock Options Prices in MSN Money Stock Addin

    JBE, Feb 11, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    321
  3. nick

    Office 2003 Stock Action Add-In - Stock Handling Capacity/Numbers

    nick, Jan 2, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    641
  4. Guest

    How can I use Dutch (NL) stock MSN MoneyCentral Stock in Excel

    Guest, Feb 16, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    211
    Guest
    Feb 16, 2006
  5. Manfred

    Web Query With Multiple Stock Symbols & Stock Scouter

    Manfred, Mar 1, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    436
    Manfred
    Mar 1, 2006
Loading...

Share This Page