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 (=).
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 (-), asterisk(*), or forward slash (/) signs.
Multiply a column of numbers by the same number
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.
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 ( - ), …
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.
Calculation operators and precedence in Excel - Microsoft Support
Operators specify the type of calculation that you want to perform on elements in a formula—such as addition, subtraction, multiplication, or division. There are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference.
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.
Using calculation operators in Excel formulas - Microsoft Support
To perform basic mathematical operations, such as addition, subtraction, multiplication, or division; combine numbers; and produce numeric results, use the following arithmetic operators.
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%.
Perform conditional calculations on ranges of cells
You can use arrays that evaluate as True or False (1 or 0) as criteria by using them as factors (multiplying them by the other arrays). For example, suppose you want to calculate net sales for a particular sales agent by subtracting expenses from gross sales, as in this example.