How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Richard Your Own Question
Richard
Richard, Computer Support Specialist
Category: Computer
Satisfied Customers: 38371
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

Resolved Question:

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
Submitted: 2 years ago.
Category: Computer
Expert:  Richard replied 2 years ago.
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

Expert:  Richard replied 2 years ago.
ok, ill look at it now Adam
Expert:  Richard replied 2 years ago.
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

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

spot on - thank you.

Expert:  Richard replied 2 years ago.
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