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.

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 …

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

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 …

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

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

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 …

Note that Excel calculates times as a fraction of a day, so you need to multiply by 24 to get the total hours. In the first example we're using = ( (B2-A2)+ (D2-C2))*24 to get the sum of hours …

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