Feb 27 2023 06:49 AM - edited Feb 27 2023 07:34 AM
11, using lookup, lookup the value in column 10, write “Gain” if the value in column 10 is greater than “one” otherwise “Loss”. what is the formula?
Feb 27 2023 07:12 AM
This looks like a homework assignment, so you should try to solve it yourself.
Apart from that: is that really the complete text of this assignment?
Feb 27 2023 07:21 AM
@Sasha_Small I might be willing to provide a hint, but to be honest the question as asked makes little sense to me:
"using lookup, lookup the value in column 10"
Look up what? That's why I asked whether the question was complete.
Feb 27 2023 07:33 AM
@Hans Vogelaar In Column 11, using lookup, lookup the value in column 10, write “Gain” if the value in column 10 is greater than “one” otherwise “Loss”.
Feb 27 2023 07:36 AM
Thanks. I'm afraid it's still not clear to me what you want to look up in column 11.
Feb 27 2023 07:45 AM
Sorry, I hadn't noticed that you edited the first post.
The first row with data is row 3. The formula in K3 has to look at the value of J3.
If J3 is >1, return "Gain", otherwise return "Loss".
That is basically the recipe - you can use the IF function
Does that give you a start?
Feb 27 2023 07:49 AM