Multiply and divide numbers in Excel - Microsoft Support
Create a simple formula to multiply and divide in an Excel spreadsheet. You can multiply two or more numbers in one cell or multiply and divide numbers using cell references. All formulas in Excel begin with an equal sign (=).
Multiply a column of numbers by the same number
Suppose you want to multiply a column of numbers by the same number in another cell. The trick to multiplying a column of numbers by one number is adding $ symbols to that number's cell address in the formula before copying the formula.
Create a simple formula - Microsoft Support
You can create a simple formula to add, subtract, multiply, or divide values in your worksheet. Simple formulas always start with an equal sign ( = ), followed by constants that are numeric values and calculation operators such as plus ( + ), minus ( - ), …
Multiply by a percentage - Microsoft Support
To calculate the amount, use a formula to subtract or add a percentage. In this example, we set column B to contain the amount currently spent, and column C is the percentage by which to reduce that amount. Here's is a formula you could enter in cell D2 to accomplish this: =B2*(1-C2) In this formula, 1 is equivalent to 100%.
Create a simple formula in Excel - Microsoft Support
You can create a simple formula to add, subtract, multiply or divide values in your worksheet. Simple formulas always start with an equal sign ( = ), followed by constants that are numeric values and calculation operators such as plus ( + ), minus ( - ), …
Multiply a column of numbers by the same number - Microsoft …
The trick to multiplying a column of numbers by one number is adding $ symbols to that number's cell address in the formula before copying the formula. In our example table below, we want to multiply all the numbers in column A by the number 3 in cell C2.
PRODUCT function - Microsoft Support
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.
Use Excel as your calculator - Microsoft Support
You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. Or use the AutoSum feature to quickly total a series of values without entering them manually in a formula.
MMULT function - Microsoft Support
The MMULT function returns the matrix product or multiplication of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. The way you enter the formula depends on which version of Office 365 you are using.
SUMPRODUCT function - Microsoft Support
How to use the SUMPRODUCT function in Excel, one of Excel’s math and trig functions, using multiplication, addition, subtraction, and/or division to return the sum of the products of corresponding ranges or arrays.