![]() Be sure to include a $ symbol before B and before 2 in the formula, and press ENTER. Type =A2*$B$2 in a new column in your spreadsheet (the above example uses column D). In this example, the number you want to multiply by is 3, contained in cell C2. To enter a non-function formula in Excel, type an equal sign, then the equation using the standard mathematical operators and numeric values and/or cell references. Suppose you want to multiply each cell in a column of seven numbers by a number that is contained in another cell. Excel uses the equal symbol to recognize formulas (and by extension, functions). Multiply a column of numbers by a constant number To do this task, use the * (asterisk) arithmetic operator.įor example, if you type =5*10 in a cell, the cell displays the result, 50. There are several ways to multiply numbers. Let'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). Just remember that all formulas in Excel begin with an equal sign (=), and you can use the formula bar to create them. ![]() ![]() Multiplying and dividing in Excel is easy, but you need to create a simple formula to do it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |