### 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?

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…

### What is the formula for multipling two cells together in excel?

If you had the two cells A2 and A3 and wanted to multiply them, then the simplest formula is: =A2*A3 If you had the two cells A2 and A3 and wanted to multiply them, then the simplest formula is: =A2*A3 If you had the two cells A2 and A3 and wanted to multiply them, then the simplest formula is: =A2*A3 If you had the two cells A2 and A3 and wanted to multiply them, then…

### What is the answer for 3 over a plus 2 over a to the second power minus 1 over a to the third power?

### How do you write 12 percent in an Excel formula?

You can do it as a decimal or with the percent sign. So both of the following formulas will do the same thing: =A3*12% =A3*0.12 You can do it as a decimal or with the percent sign. So both of the following formulas will do the same thing: =A3*12% =A3*0.12 You can do it as a decimal or with the percent sign. So both of the following formulas will do the same thing: =A3*12% =A3*0.12…

### How many A3 sheets fit into A1 sheet?

A3 is 4 times bigger than A1, so only a quarter of an A3 sheet can fit into an A1 sheet. A3 is 4 times bigger than A1, so only a quarter of an A3 sheet can fit into an A1 sheet. A3 is 4 times bigger than A1, so only a quarter of an A3 sheet can fit into an A1 sheet. A3 is 4 times bigger than A1, so only a quarter of…