Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 More...Less Show
Multiplying and dividing in Excel is easy, but you need to create a simple formula to do it. Just remember that all formulas in Excel begin with an equal sign (=), and you can use the formula bar to create them. Multiply numbersLet's say you want to figure out how much bottled water that you need for a customer conference (total attendees × 4 days × 3 bottles per day) or the reimbursement travel cost for a business trip (total miles × 0.46). There are several ways to multiply numbers. Multiply numbers in a cellTo do this task, use the * (asterisk) arithmetic operator. For example, if you type =5*10 in a cell, the cell displays the result, 50. Multiply a column of numbers by a constant numberSuppose you want to multiply each cell in a column of seven numbers by a number that is contained in another cell. In this example, the number you want to multiply by is 3, contained in cell C2.
Multiply numbers in different cells by using a formulaYou can use the PRODUCT function to multiply numbers, cells, and ranges. You can use any combination of up to 255 numbers or cell references in the PRODUCT function. For example, the formula =PRODUCT(A2,A4:A15,12,E3:E5,150,G4,H4:J6) multiplies two single cells (A2 and G4), two numbers (12 and 150), and three ranges (A4:A15, E3:E5, and H4:J6). Divide numbersLet's say you want to find out how many person hours it took to finish a project (total project hours ÷ total people on project) or the actual miles per gallon rate for your recent cross-country trip (total miles ÷ total gallons). There are several ways to divide numbers. Divide numbers in a cellTo do this task, use the / (forward slash) arithmetic operator. For example, if you type =10/5 in a cell, the cell displays 2. Important: Be sure to type an equal sign (=) in the cell before you type the numbers and the / operator; otherwise, Excel will interpret what you type as a date. For example, if you type 7/30, Excel may display 30-Jul in the cell. Or, if you type 12/36, Excel will first convert that value to 12/1/1936 and display 1-Dec in the cell. Note: There is no DIVIDE function in Excel. Divide numbers by using cell referencesInstead of typing numbers directly in a formula, you can use cell references, such as A2 and A3, to refer to the numbers that you want to divide and divide by. Example: The example may be easier to understand if you copy it to a blank worksheet. How to copy an example
Divide a column of numbers by a constant numberSuppose you want to divide each cell in a column of seven numbers by a number that is contained in another cell. In this example, the number you want to divide by is 3, contained in cell C2.
Note: Using $ symbols tells Excel that the reference to C2 is "absolute," which means that when you copy the formula to another cell, the reference will always be to cell C2. If you didn't use $ symbols in the formula and you dragged the formula down to cell B3, Excel would change the formula to =A3/C3, which wouldn't work, because there is no value in C3. Need more help?You can always ask an expert in the Excel Tech Community or get support in the Answers community. See AlsoMultiply a column of numbers by the same number Multiply by a percentage Create a multiplication table Calculation operators and order of operations Need more help?What is the correct spreadsheet formula for multiplying cell?Suppose you want to multiply each cell in a column of seven numbers by a number that is contained in another cell. In this example, the number you want to multiply by is 3, contained in cell C2. Type =A2*$B$2 in a new column in your spreadsheet (the above example uses column D).
What is the correct spreadsheet formula for multiplying 50 and 233?1. What is the correct spreadsheet formula for multiplying 50 and 233? Correct: =50*233 is the correct formula for multiplying 50 and 233.
How do you multiply multiple cells in Excel?You can use the Paste Special function to multiply a range of cells by a number as follows:. Input the number 8.7 into a blank cell and copy it.. Select the range that you want to multiply a value, and click Home > Paste > Paste Special.. How do you make a multiplication formula in Google Sheets?These steps can help you use the MULTIPLY formula in your spreadsheet:. Select your active cell.. Type "=" to start your formula.. Type "MULTIPLY" followed by a parenthesis.. Enter the first number you want to multiply.. Add a comma.. Enter the second number you want to multiply.. Add a closing parenthesis.. Press "Enter.". |