# How do i work out this formula on Excel?

Watch
Announcements
Thread starter 1 year ago
#1
Hiya i`m having problems with this formula on one of the practice exams.

Its asking me what formula should i use to work out how much money was taken in orange juice sales and believe me i have done all forms of formula possible ti work out the answer and it is still wrong, so can anyone help?
0
Thread starter 1 year ago
#2
Here is the exam question, i have not a clue on how to solve it. Could someone be able to explain to me the answer. Thank You!
0
1 year ago
#3
(Original post by Yusufjq14)
Here is the exam question, i have not a clue on how to solve it. Could someone be able to explain to me the answer. Thank You!
Money made from orange juice sales would be cost of orange juice multiplied by the amount you sold. That would give you total. I hope that puts you in the right direction.
0
Thread starter 1 year ago
#4
(Original post by 8472)
Money made from orange juice sales would be cost of orange juice multiplied by the amount you sold. That would give you total. I hope that puts you in the right direction.
Would i write that as =C4*B4 Or the other way around?
0
1 year ago
#5
(Original post by Yusufjq14)
Would i write that as =C4*B4 Or the other way around?
Either way will work but generally you would do it column order. So =B4*C4
0
1 year ago
#6
Which functions have you tried?
As it's asking for the money made for a specific item in the table I would use a VLOOKUP.
Last edited by (づ￣ ³￣)づ; 1 year ago
0
X

new posts
Back
to top
Latest
My Feed

### Oops, nobody has postedin the last few hours.

Why not re-start the conversation?

see more

### See more of what you like onThe Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

### Poll

Join the discussion

#### Should there be a new university admissions system that ditches predicted grades?

No, I think predicted grades should still be used to make offers (700)
33.9%
Yes, I like the idea of applying to uni after I received my grades (PQA) (881)
42.66%
Yes, I like the idea of receiving offers only after I receive my grades (PQO) (392)
18.98%
I think there is a better option than the ones suggested (let us know in the thread!) (92)
4.46%