Change value in a cell based on value in another cell

Searched for this but could not find a way to do it. I would like to be able to transform a value in one cell to another value in a different cell like this: When cells in Column `A` contain `Y` set same number cells in Column `B` to `Male` or when cells in Column `A` contains `N` set same number cells in Column `B` value to `Female`. For instance: ``` A2 = Y then B2 = Male A2 = N then B2 = Female ```