Microsoft Excel is a powerful tool; so powerful you can use it to perform basic mathematic equations. For example, if you want to multiply numbers, you can do this in Excel with relative ease. Now, you can only multiply in a single cell, more than one cell, and an entire column. In this post, we will show you how to multiply numbers in a single cell & how to multiply numbers from several cells in Microsoft Excel.
How to multiply numbers in Excel
Knowing how to multiply in Microsoft Excel is very important for any professional, student, etc. Begin by launching Microsoft Excel on your Windows computer. To do this, seek out the Excel icon on your Desktop, Taskbar, or from within the Start Menu. Click on Blank Workbook to open a new Excel sheet, or open a sheet you’ve already been working on prior.
How to multiply numbers in a single cell in Excel
OK, so after you’ve fired up Microsoft Excel and opened a workbook, it’s now time to do some multiplication. We are going to begin by multiplying numbers in a single cell.
Select the cell you want to work with
Yes, the first thing you must do here, is to select the preferred cell by clicking on it. See how easy that was? Simple, yet effective.
Enter the correct formula
The next step, then, is to enter the required formula for the multiplication equation to work. The formula in question is as follows:
=a*b
Ensure the formula is added in the formula area at the top or else you will likely face problems.
Multiply numbers in the cell
After adding the formula, return to the cell and replace a and b with the numbers you want to use. For example, if you want to multiply 27 by 15, then you would enter the following into the cell:
=27*15
Hit the Enter key and you should now see the results.
How to multiply multiple numbers from several cells in Excel
There may come a time when you feel the need to multiply numbers that are situated in different cells. The question is, how do we do this? Let’s talk about that.
Add the numbers to the required cells
What you need to do right now, is to add the numbers to the relevant cells. These are the numbers you want to calculate, so ensure they are correct.
Multiply the numbers
Now, if the numbers are in A1 and A2, then the formula should look like the following:
=A1*A2
Bear in mind you will want to add the formula in a different cell. For example, you could add the formula in C1 for the correct results to appear there.
How to multiply a column of numbers by a constant number
As for multiplying numbers in a column, this is something Excel is capable of. As you might expect, the task is very similar to multiplying numbers in two cells. You just have to make commonsense changes. However, in terms of multiplying with a constant number, the formula is much different.
Add the numbers to the column
First, you must add the preferred set of numbers to a column. You can decide however long you want it to be. From the image, our numbers range from A1 to A8.
Select a cell for the constant number
You will now need to choose a cell to place the constant number. In this demonstration, we’ve decided to use C1, so click within and input the preferred constant number
Choose a cell for the results
Next up, you must select a cell for where the results will appear. We decided to work with B1, so you can do that as well. From there, add the following formula:
=A1*$C$1
Hit the Enter key on your keyboard and right away the results will appear. You can perform the calculations yourself to see if Excel is on point.
Is there a Multiply function in Microsoft Excel?
Yes, there is a function in Microsoft Excel that supports multiplication. The PRODUCT function multiplies all the numbers given as arguments and returns the product. For example, if cells A1 and A2 contain numbers, you can use the formula =PRODUCT(A1, A2) to multiply those two numbers together. You can also perform the same operation by using the multiply (*) mathematical operator; for example, =A1 * A2. For more on this, you can visit Microsoft.com. (Thanks for this Chris Tucker – Admin)
What is Math function in Excel?
There are some common Math functions that can be used regularly as part of your work in Excel. These include SUM, COUNTA, MOD function, AVERAGE, etc. Add an equal sign before the function and provide cell numbers to get the output. For example, if you want to calculate the sum of A1 to A10 cells. Then, the formula with the Math function will be =SUM(A1:A10).
Read next: How to create a Gauge Chart in Excel.
