In our example, we want to reference cell E14 on the Menu Order worksheet.
The result of this formula would be 34.) Summary – how to multiply in Excel 2013 =(5*6)+4 (This formula incorporates parentheses to perform the multiplication formula inside the parentheses, then add 4 to the result of that multiplication. Using the example image above, this would result in a total of 56.) =A2*7 (This formula will multiply the value in cell A2 x 7. =5*6 (This formula will multiply 5 x 6 and display “30” in the cell.) Step 2: Click inside the cell where you would like to display the result of the multiplication formula.Įxcel 2013 Multiplication Formula VariationsĪs mentioned previously, this multiplication formula can be modified to include numbers, and not just cell values.
Step 1: Open your worksheet in Excel 2013. If you need to quickly combine data from multiple cells, then our concatenate Excel article can show you how. You can then adjust the formulas displayed on this page to include the numbers that you need to multiply. Our guide will provide an example where two cell values are multiplied together, but we will also provide example formulas that incorporate cell references and numbers. You can have Excel multiply cell values, numbers, or a combination of cell values and numbers.
How to Multiply in Excel 2013 Using Cell Values The end result will be a cell that displays the result of that multiplication. Our tutorial below will show you how to multiply numbers and/or cell values with the use of a formula in Excel 2013. Fortunately this is the case, although the method for doing so might not be obvious. So, given that these mathematical functions exist within the program, it only seems natural that you could multiply numbers in Excel 2013 as well. Microsoft makes the addition formula very accessible in Excel 2013, and you have probably even figured out how to subtract with a formula in Excel.
If you are trying to figure out how to multiply in Excel 2013, then you might be struggling to find the formula or option to do so.