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 …

There are several ways to multiply numbers. To do this task, use the * (asterisk) arithmetic operator. For example, if you type =5*10 in a cell, the cell displays the result, 50. Suppose you …

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 …

Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. Or use the AutoSum feature …

How to create simple formulas in Excel using AutoSum and the SUM function, along with the add, subtract, multiply, or divide values in your worksheet.

Perform conditional calculations on ranges of cells. Sum based on multiple criteria with SUMIFS.

You can help your users fill out forms based on your form template by using formulas to calculate the value for a control, based on data that the user enters into other controls. The calculations …

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 …

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

Using formulas in calculated columns in lists can help add to existing columns, such as calculating sales tax on a price. These can be combined to programmatically validate data. To add a …

Explore how-to articles, guides, training videos, and tips to efficiently use Excel.