Hi All, another question on IF Statements...
Column A lists a bunch of sports (ex. Soccer, Hockey, Golf, Baseball)
How would I create the following helper column in B1:
If A1 = "Soccer" or "Golf", then B1 replicates that value (either 'Soccer' or 'Golf').........but if A1 has any sport other than Soccer or Golf (ex. Hockey or Baseball), then input value "Other" in B1.
THanks!!!!
Bookmarks