Change value in a cell based on value in another cell

Question

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

User · Answer

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

User · Answer

If you want to do something like the following example  you d have to use nested ifs     If percentage is greater than or equal to 93   then corresponding value in B should be 4 and if the percentage is greater than or equal to 90  and less than 92   then corresponding value in B to be 3 7  etc   Here s how you d do it    IF A2 gt  93   4  IF A2 gt  90   3 7 IF A2 gt  87  3 3 0

User · Answer

IF A2  Y   Male  IF A2  N   Female

[excel] Change value in a cell based on value in another cell

Examples related to excel

Examples related to transform