I have a table. If column 3 is "fast" AND column 4 contains any of these characters: boat, car, or airplane. then column 5 become those strings on column 4. If it meets just the "fast" in column 3, then column 5 becomes "fast". Otherwise it's none. Do I need an if else statement? Or how would I do this?
column 3fastfastslowmediumfastcolumn 4mike boat daypax airplane oscarshipcartraincolumn 5boatairplanenonenonefast
Best Answer