Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default stock remaining..

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 153
Default stock remaining..

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How many days the ready stock+expected stock will last as allocate Narnimar Excel Discussion (Misc queries) 0 September 16th 08 05:57 PM
Stock control formulas, counting and reporting remaining stock santaviga Excel Programming 2 October 23rd 06 01:34 PM
Web Query With Multiple Stock Symbols & Stock Scouter Manfred Excel Worksheet Functions 0 March 1st 06 09:13 PM
How can I use Dutch (NL) stock MSN MoneyCentral Stock in Excel Jeroen Excel Worksheet Functions 0 February 16th 06 03:14 PM
Office 2003 Stock Action Add-In - Stock Handling Capacity/Numbers nick Excel Worksheet Functions 0 January 2nd 06 09:22 PM


All times are GMT +1. The time now is 01:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"