Budget remaining

S

salman.way

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.
 
S

Spencer101

Suppose I have a expense head Internet and have Internet budget sa
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 sho
me the remaining budget.

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

+-------------------------------------------------------------------
|Filename: salman.way example.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=524
+-------------------------------------------------------------------
 
A

Auric__

salman.way said:
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.)
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top