Forum Discussion

Sasha_Small's avatar
Sasha_Small
Copper Contributor
Feb 27, 2023

HELPPPP

 

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?

 

10 Replies

  • Sasha_Small 

    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?

      • HansVogelaar's avatar
        HansVogelaar
        MVP

        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.

Resources