I have three columns of data, column A, B & C.

I want to write an IF statement that looks at column A,
and if it either retruns the contents of column B or
column C depending on the match.

eg.
Column A Car
Column B Non public transport
Column C Public transport

If column A = "Car" then return "Non public transport"
else
return "Public transport"