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.

Originally Posted by

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?

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.