This is probably a very simple fix but I cannot figure it out.
I need an if statement that allows me to do the following:
In cell A1 I put the person's gender, either an M or an F.
Then in Cell A2 I want an if statement that will refer the cell A2 to a formula in another cell. For example cell A5.
A1 A2 A5
M If Cell A1 = M then execute the formula in cell A5 =vlookup...
I need an if statement that allows me to do the following:
In cell A1 I put the person's gender, either an M or an F.
Then in Cell A2 I want an if statement that will refer the cell A2 to a formula in another cell. For example cell A5.
A1 A2 A5
M If Cell A1 = M then execute the formula in cell A5 =vlookup...