I would like a formula for column "C" that will output one of the following four values:
1) = "100" when column "A" value is negative and column "B" value is "W"
2) = (value of column "A") when column "A" value is positive and column "B" value is "W"
3) = "-100" when column "A" value is positive and column "B" value is "L"
4) = (value of column "A") when column "A" value is negative and column "B" value is "L"
My spreadsheet looks like column "A" and "B", but I'd like the values in column "C" to appear automatically via formula.
A B C
-143 W [100]
111 W [111]
167 L [-100]
-125 L [-125]
Bookmarks