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.

Let's say you want to help a child to better understand math concepts by creating a multiplication table. Enter numbers 1-10 in cells A2 to A11 and again in cells B1 to K1.

Learn how to multiply an entire column of numbers by a percentage and to reduce or increase an amount by a percentage.

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. …

For simple formulas, simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use — the plus sign (+) to add, the minus …

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 …

The PRODUCT function is useful when you need to multiply many cells together. For example, the formula =PRODUCT (A1:A3, C1:C3) is equivalent to =A1 * A2 * A3 * C1 * C2 * C3.

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 …

Following the standard order of mathematical operations, multiplication is performed before addition. On the worksheet, click the cell where you want to enter the formula. Type the = …

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.