# What computer program?

Ok I'm looking for a compter program that is similar to Excel where I can enter any information into any cell.

However, this is for inventory.

So I would want an equation part of it also. I cannot find it on Excel and that is why im trying to look elsewhere.

I want to be able to know how much of an item I have on stock always.

Say I get 10 items shipped, so I enter 10 in the "recieving" cell and then it tells me 10 in the total.

Then I use 2 items, so I enter 2 in the "used" cell and then it tells me 8 in the total.

But then I buy 10 more, so I enter 10 in the "receiving" cell and it should give me 18 in the total.

I only got excel to give me 8 still. I understand but I have no idea.

If anyone can give me detailed instructions (don't know to much about Excel) or a program that will do this, that would be great.

Thanks

Relevance
• Anonymous

I know some basics of Excel that I learned in school. There is an equation part to it. I can help you with it. I told you I know more about computers than you, but you didn't believe me. You should have asked me this question.

• Yoi_55
Lv 7

You cannot just enter "10" again and expect it to add 10. It will overwrite what you have in there with whatever you type in (in this case, 10). So, if you have 15 in receiving and 5 in used, the total will be 10, but it you replace the 15 in receiving with a 10 your total will be 5 because the 10 overwrote the 15.

Excel is capable of doing this, but you can also use the spreadsheet in the OpenOffice instead.

In any case, you need more cells, e.g. a column for "receiving" inventory, and also for "used". Each time you receive something, you write it in a new "receiving" cell. In a separate cell (preferably in another column) you compute the sum over all "receiving" cells. Do the same for "used": each time you use a couple of items, write this down in a separate cell of the "used" column. Add this column together in a separate cell. The final inventory is the difference between the two sums.