Apache OpenOffice Community Forum

Hello Guys!

I'm a bit of a newbie at this but need just a simple formula for a stock levels sheet I use.

Lets say column E is the quantity in stock of each item
Column F will be the amount of sales of that item on a particular website.

So item 1 E2 has Qty 10 in stock
I have 2 sales of this item

Is it possible for me to just tap the number 2 into E2 and have that figure deducted from E2 so it equals 8 and then have that number increased to F2 by 2

It's so I can easily just hit the numbers on the keyboard and all this is done automatically for me, at the moment I am manually going to each cell and deducting the number, obviously I might start to make errors whilst doing this...

Even better would be that if the QTY reaches say 2 it will turn to red text as well!

That would be awesome if possible!

I hope I have made sense.

Thanks Guys!

purchases in one column, sales in another column.
=SUM(purchase)-SUM(sales)+STYLE(IF(CURRENT()<3;"red style"))

Hi Thanks

Would this deduct the number of sales in the QTY column?

So I have 10 of widget1
I sell 2 in a day
I just tap 2 into the cell with the QTY 10 and the figure would be reduced to 8, and also the sales total cell would increase by 2.

It's just so I can keep track of stock and monitor how many sales I am achieving in each item and give me a warning if I am running low.

Do I have to label the columns “purchase” and “sales”?

I'm not sure If I am making myself clear as I have little experience with these types of documents.

http://forum.openoffice.org/en/forum/do ... p?id=14074

Tools>Options>Calc>Calculation... all check boxes OFF except for "... match whole cell"=ON
purchases in one column, sales in another column, item in A1
=SUMIF(purchase;A1)-SUMIF(sales;A1)+STYLE(IF(CURRENT()<3;"red style"))