Forum Discussion
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?
if you are not here to help why respond though?
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.
HansVogelaar 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”.
Thanks. I'm afraid it's still not clear to me what you want to look up in column 11.
- thats the excel sheet we are working with and thats a question