How JustAnswer Works:
• Ask an Expert
• Get a Professional Answer
• 100% Satisfaction Guarantee
Ask Richard Your Own Question
Richard, Computer Support Specialist
Category: Computer
Satisfied Customers: 40857
Experience:  Over 15 years of consulting to the IT industry
32989067
Type Your Computer Question Here...
Richard is online now

# Help with a spreadsheet stock, and a formula that

This answer was rated:
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
Upload the file, and provide me the download link please.
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 .

not sure how to do this. ask if more info required or adaminnit sky pe

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
Richard and other Computer Specialists are ready to help you
Customer: replied 2 years ago.

spot on - thank you.

Your welcome
If you need anything else, let me know and please remember the service rating by clicking one of the stars at the top.
Thanks