Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]() Quote:
Is this what you mean? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
salman.way 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. This is *very* basic stuff. Have you ever used a spreadsheet before? Are you perhaps taking a class? I'm assuming that the header row is row 1, the first data row is row 2, and the first column is column A. The first "Budget remaining" cell needs this formula: =10000-D2 The second "Budget remaining" cell needs this formula: =E2-D3 For all additional rows, just copy the bottom "Budget remaining" cell down. (Do *NOT* copy the top "Budget remaining" cell down.) -- If there is a possibility of several things going wrong, they will all happen at once. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Percentage remaining | Excel Discussion (Misc queries) | |||
stock remaining.. | Excel Worksheet Functions | |||
#of days remaining to the EOM | Excel Discussion (Misc queries) | |||
Divide Monthly Sales Budget to Day budget | Excel Programming | |||
Divide Monthly Sales Budget to Day Budget | Excel Worksheet Functions |