![]() |
Budget 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. |
1 Attachment(s)
Quote:
Is this what you mean? |
Budget remaining
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. |
All times are GMT +1. The time now is 10:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com