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.

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 …

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

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

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. Enter this formula in …

Create a simple formula in a cell to add, subtract, multiply, or divide numbers by using +, -, *, and /.

For example, the following formula results in the value of 11, because Excel calculates multiplication before addition. The formula first multiplies 2 by 3, and then adds 5 to the result.

To perform basic mathematical operations, such as addition, subtraction, multiplication, or division; combine numbers; and produce numeric results, use the following arithmetic operators.

If a formula contains operators with the same precedence—for example, if a formula contains both a multiplication and division operator—Excel evaluates the operators from left to right.