![]() ![]() In this example, the number you want to multiply by is 3, contained in cell C2. Suppose you want to multiply each cell in a column of seven numbers by a number that is contained in another cell. 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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |