根据另一个单元格中的值更改单元格中的值

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'

当A列中的单元格包含'Y'时，将B列中相同数字的单元格设置为'Male'，或者当A列中的单元格包含'N'时，将B列中的相同数字单元格设置为'Female'

For instance, A2 = Y then B2 = Male A2 = N then B2 = Female

例如，A2 = Y然后B2 =男性A2 = N然后B2 =女性

Thanks in advance for any suggestions.

在此先感谢您的任何建议。

~eric

〜埃里克

2 个解决方案

#1

=IF(A2="Y","Male",IF(A2="N","Female",""))

#2

by typing yes it wont charge taxes, by typing no it will charge taxes.

通过键入是它不会收税，通过键入否它将收取税。

=IF(C39="Yes","0",IF(C39="no",PRODUCT(G36*0.0825)))