0
Add your answer:
Earn +20 pts
How do you perform multiplication in a spread sheet?
To carry out the multiplication directly in the cell type in the formula preceded by = and using asterisks (*) for the multiplication symbol. For example, =240*4. To multiply the contents of two existing cells use a formula similar to =B12*C12. To avoid mistakes click on the cell in question, rather than typing its address.
What is the formula used to calculate result in Microsoft Excel?
The formula you use depends upon what you are trying to calculate. If you want to multiply two cells (e.g. A1 and C2), the formula would be =A1*C2.
What is the formula for this question?
The answer is in cell C1.Put "this" in cell A1.Put "question" in cell B1.Put the following formula in C1: =A1&" "&B1
How do you write a formula in cell b1 in excel that shows if cell a1 is greater than 4 enter the number 150 or if cell a1 is less than 4 enter 75?
=IF(A1>4,150,75) In this case if A1 is 4, then 75 will show. If you want 150 to show when A1 is 4 then the formula would be: =IF(A1>=4,150,75)
What would the Excel formula be for If the text in Cell A1 matches the Text in Column A on Sheet 2 then place an X in Cell B1 on Sheet 1?
If you want to compare the contents of cell A1 on Sheet1 to A1 on Sheet2 and put an X in cell B1 on Sheet1, then in cell B1 on Sheet1 you would put the following formula: =IF(A1=Sheet2!A1,"X","")
In Excel which symbol is the mathematical operator for multiplication?
You use the * key, which can be found on the numeric keypad.
What is the formula that divides the value of the cell A1?
You can divide by anything except zero. So you can use a number or a cell with a number in it. You use the / symbol for division. So your formula to divide something in cell A1, which must go into a cell other than A1, could be like either of the following: =A1/10 =A1/B2
What is in a formula in a spreadsheet?
A simple formula put into D1 could be: =A1*B1 Which is asking the numerical data in cell A1, be timed by the numerical data in cell B1, and show the answer in cell D1.
What is the formula of take away in excell?
Assuming "take away" means to subtract, here is the formula for subtracting the contents of cell B1 from the contents of cell A1:=A1-B1
In excel if value is in one column automaticlly put formula in another column?
There is no way to have a value in one cell put a formula in another cell. However, you can put a formula in a cell that will change, based on the value of another cell. If you put the formula =A1 in cell B1, B1 will display the value of whatever you place in cell A1.
How can you enter into a cell in excel and have it record to another worksheet?
If you have a value in cell A1 on Sheet1 and you want it to appear in Sheet 2, you use a formula. So in a cell on Sheet2 type: =Sheet1!A1 Sheet1 is the sheet name. The exclamation mark separates it from the cell reference. Now whatever is in the cell A1 on Sheet1 will appear in the cell with that formula.
How do you convert the number into text in Microsoft Excel?
Format the cell as text. You also can input a formula: =text(A1) Remark: if the content is in cell A1.
