0
What is the formula in Excel to take one cell if a certain cell is yes if that cell is no then take a different cell eg if cell a3 is yes then take a1 if a3 is no then take a2?
Wiki User
∙ 11y ago
You would use an IF function to do this. If you knew that A3 can only have yes or no in it, then in another cell you would put this:
=IF(A3="yes",A1,A2)
If it is possible that A3 might not have yes or no in it, then you would need to have a third action, like leave the cell blank or put zero into. In this case the formula would be:
=IF(A3="yes",A1,IF(A3="no",A2,""))
or
=IF(A3="yes",A1,IF(A3="no",A2,0))
Note that there are two brackets at the end because there are two IF functions. It would be safer to use one of the final two formulas, as if A3 was blank, you would get an error. You should also be careful to have the yes and no in the same case all the time, although Excel will say they are equal if it was like yes and YES.
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
Where Excel displays the formula that is in a cell IS WHAT?
The formula bar.
When you enter a formula in a cell Excel assigns the cell the same format as the cell reference in the formula?
first
What do you have to put in a cell to denote an equation in Excel?
In Excel an equation can be a formula. All formulas in Excel must start with the equals sign. That is what tells Excel it is a formula.
In Excel what can be assigned to a cell that will display a calculated result?
formula
What is Cell entry that performs a computation in excel?
A formula.
How does Excel recognize that you are entering a formula into a cell?
All formulas must begin with the equals sign. That is how Excel knows it is a formula.
What does a green arrow in the corner of an Excel cell mean?
A green arrow in the corner of an excel cell means that excel suspects soemthing may be wrong with the formula in a particular cell.
Where is the location where the data will appear in Excel?
In a cell and in the formula bar.In a cell and in the formula bar.In a cell and in the formula bar.In a cell and in the formula bar.In a cell and in the formula bar.In a cell and in the formula bar.In a cell and in the formula bar.In a cell and in the formula bar.In a cell and in the formula bar.In a cell and in the formula bar.In a cell and in the formula bar.
Where is the formula keyed in for Excel?
Formulas go into cells. You can type them directly into a cell or on the formula bar, which will then enter it into the selected cell.
How do you cancel the formula that you entered into an excel?
You place your cursor in the cell, and delete the formula.
What does REF mean in Excel?
The #REF error in Excel indicates that Excel is trying to reference a cell that does not exist. It often happens when rows or columns or removed, or cells are deleted completely, leaving the formula unable to find the cell that it is trying to reference. You will see it in place of a cell in the middle of a formula, indicating the cell it cannot find.The #REF error in Excel indicates that Excel is trying to reference a cell that does not exist. It often happens when rows or columns or removed, or cells are deleted completely, leaving the formula unable to find the cell that it is trying to reference. You will see it in place of a cell in the middle of a formula, indicating the cell it cannot find.The #REF error in Excel indicates that Excel is trying to reference a cell that does not exist. It often happens when rows or columns or removed, or cells are deleted completely, leaving the formula unable to find the cell that it is trying to reference. You will see it in place of a cell in the middle of a formula, indicating the cell it cannot find.The #REF error in Excel indicates that Excel is trying to reference a cell that does not exist. It often happens when rows or columns or removed, or cells are deleted completely, leaving the formula unable to find the cell that it is trying to reference. You will see it in place of a cell in the middle of a formula, indicating the cell it cannot find.The #REF error in Excel indicates that Excel is trying to reference a cell that does not exist. It often happens when rows or columns or removed, or cells are deleted completely, leaving the formula unable to find the cell that it is trying to reference. You will see it in place of a cell in the middle of a formula, indicating the cell it cannot find.The #REF error in Excel indicates that Excel is trying to reference a cell that does not exist. It often happens when rows or columns or removed, or cells are deleted completely, leaving the formula unable to find the cell that it is trying to reference. You will see it in place of a cell in the middle of a formula, indicating the cell it cannot find.The #REF error in Excel indicates that Excel is trying to reference a cell that does not exist. It often happens when rows or columns or removed, or cells are deleted completely, leaving the formula unable to find the cell that it is trying to reference. You will see it in place of a cell in the middle of a formula, indicating the cell it cannot find.The #REF error in Excel indicates that Excel is trying to reference a cell that does not exist. It often happens when rows or columns or removed, or cells are deleted completely, leaving the formula unable to find the cell that it is trying to reference. You will see it in place of a cell in the middle of a formula, indicating the cell it cannot find.The #REF error in Excel indicates that Excel is trying to reference a cell that does not exist. It often happens when rows or columns or removed, or cells are deleted completely, leaving the formula unable to find the cell that it is trying to reference. You will see it in place of a cell in the middle of a formula, indicating the cell it cannot find.The #REF error in Excel indicates that Excel is trying to reference a cell that does not exist. It often happens when rows or columns or removed, or cells are deleted completely, leaving the formula unable to find the cell that it is trying to reference. You will see it in place of a cell in the middle of a formula, indicating the cell it cannot find.The #REF error in Excel indicates that Excel is trying to reference a cell that does not exist. It often happens when rows or columns or removed, or cells are deleted completely, leaving the formula unable to find the cell that it is trying to reference. You will see it in place of a cell in the middle of a formula, indicating the cell it cannot find.
What is a formula bar used for in Excel?
To enter the formula in selected cell, To view the farmula or content of selected cell.
