ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Budget remaining (https://www.excelbanter.com/excel-programming/446781-budget-remaining.html)

[email protected]

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.

Spencer101

1 Attachment(s)
Quote:

Originally Posted by (Post 1604377)
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.

Have a look at the very simple attachment.
Is this what you mean?

Auric__

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