Formulas

I need a basic formula as soon as possible! I know that I have done this type
of work before however, it has been so long since that I cannot remember how
to do it.

I have a spreadsheet with various items named on it, and the amount we have
next to it. What is the formula that I need to put in, in order to keep track
of what we have i.e. when something gets taken out of the archive, I can just
type it in and see straight away what is left?

I HOPE THIS MAKES SENSE!

many thanks.

Assumption: the quantity on hand is in column B (names in A) and all columns
beyond B available for us to use.

We'll work with row 2.

Type the amount used/removed into C2 and in D2 the formula
=B2 - C2
will give you what is left.

Now, the problem is that Excel won't 'remember' the amount left back in
column B when you delete/change the entry in C2, so you'd then need to
manually change the quantity on hand in B2 and delete the entry in C2.



"Donna" wrote:

I need a basic formula as soon as possible! I know that I have done this type
of work before however, it has been so long since that I cannot remember how
to do it.

I have a spreadsheet with various items named on it, and the amount we have
next to it. What is the formula that I need to put in, in order to keep track
of what we have i.e. when something gets taken out of the archive, I can just
type it in and see straight away what is left?

I HOPE THIS MAKES SENSE!

many thanks.

It doesn't make any sense to me, Donna.

You will need to describe in more detail the data that you have
(cells, columns, sheets etc) and what you want to do with it, then you
might get some constructive help.

Pete

On May 20, 11:30*am, Donna wrote:
I need a basic formula as soon as possible! I know that I have done this type
of work before however, it has been so long since that I cannot remember how
to do it.

I have a spreadsheet with various items named on it, and the amount we have
next to it. What is the formula that I need to put in, in order to keep track
of what we have i.e. when something gets taken out of the archive, I can just
type it in and see straight away what is left?

I HOPE THIS MAKES SENSE!

many thanks.