• 100% Satisfaction Guarantee
Richard, Computer Support Specialist
Category: Computer
Satisfied Customers: 44547
Experience:  Over 15 years of consulting to the IT industry
32989067
Richard is online now

Help with a spreadsheet stock, and a formula that

help with a spreadsheet for drinks stock, and a formula that decides where to use one column of another ... thinking sumif or if or choose but a bit stuck, need help now
Thank you for your question, my name is ***** ***** I look forward to assisting you.
Please note, click on Reply to Expert to reply to me, a rating is only needed when we are finished.
Can I look at the file and can you tell me exactly the columns involved and what you want to achieve please?
To give me the file
Go to http://ge.tt
Customer: replied 2 years ago.

http://ge.tt/1AU72iH2/v/0?c

ok - columns A + B tell me what I need to order.

J + K will update A + B

difference between A/B is just /6 as 6 drinks per pack.

Problem:

To put in values into J OR K which will update A + B .

ok, ill look at it now Adam
ok.. so if you put in 1 in K it should inxrease the value of both A and B by 6 Adam?
Customer: replied 2 years ago.

if you put 1 in K it should DECREASE A by 6 and B by 1.

if you put 1 in J it should DECREASE A by 1 and B by 1/6

Thanks
Then in A3 use
=SUM(F3+G3+H3)-(K3*6)-(J3)
And copy it down
And B3 use
=A3/6-K3-(J3/6)
And copy it down
Not sure if in B you need A3/6 but I left it there as you already had it
If you have any problems, or would like any additional information or assistance, please do not hesitate to let me know.
And if you can take a second to rate my service by clicking one of the stars at the top of the screen and then submit, that would be greatly appreciated.
Thank you