Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get relative row numbers in a range in Excel
  • How to reference named range different sheet in Excel
  • How to get address of first cell in range in Excel
  • Two-column Lookup in Excel
  • To count total rows in a range in Excel

Data Analysis Examples

  • How to Use Solver Tool in Excel
  • How to create dynamic reference table name in Excel
  • How to combine 2 or more chart types in a single chart in Excel
  • How to calculate current stock or inventory in Excel
  • Working With Tables in Excel

Data Validation Examples

  • Prevent invalid data entering in specific cells
  • Excel Data validation require unique number
  • Excel Data validation whole percentage only
  • Excel Data validation no punctuation
  • Excel Data validation unique values only

How To Multiply Numbers in Excel

by

Learn how to multiply columns and how to multiply a column by a constant.

To multiply numbers in Excel, use the asterisk symbol (*) or the PRODUCT function.

1. The formula below multiplies numbers in a cell. Simply use the asterisk symbol (*) as the multiplication operator.

Don’t forget, always start a formula with an equal sign (=).

2. The formula below multiplies the values in cells A1, A2 and A3.

3. As you can imagine, this formula can get quite long. Use the PRODUCT function to shorten your formula. For example, the PRODUCT function below multiplies the values in the range A1:A7.

Worked Example:   How to get original number from percent change in Excel

4. Here’s another example.

Explanation: =A1*A2*A3*A4*A5*A6*A7*B1*B2*B3*B4*C1*8 produces the exact same result.

Take a look at the screenshot below. To multiply two columns, execute the following steps.

5a. First, multiply the value in cell A1 by the value in cell B1.

Worked Example:   How to calculate total from percentage in Excel

5b. Next, select cell C1, click on the lower right corner of cell C1 and drag it down to cell C6.

Take a look at the screenshot below. To multiply a column of numbers by a constant number, execute the following steps.

6a. First, multiply the value in cell A1 by the value in cell A8. Fix the reference to cell A8 by placing a $ symbol in front of the column letter and row number ($A$8).

6b. Next, select cell B1, click on the lower right corner of cell B1 and drag it down to cell B6.

Worked Example:   How to enter Today's Date or Static Date and Time in Excel

Explanation: when we drag the formula down, the absolute reference ($A$8) stays the same, while the relative reference (A1) changes to A2, A3, A4, etc. You can also use Paste Special to quickly multiply a range of cells by a constant number.

Post navigation

Previous Post:

Count Unique Values in Excel

Next Post:

Calculating Percentages in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Manipulating text strings using Left, Mid, Right, Len, Substitute in Excel
  • Extract most frequently occurring text in Excel
  • How to pad text to match equal length in Excel
  • How to find nth occurrence of character in Excel
  • How to compare two text strings in Excel
  • Get work hours between dates and times in Excel
  • How to calculate percent of year complete in Excel
  • How to show last updated date stamp in Excel
  • Dynamic date list in Excel
  • Get days between dates ignoring years in Excel
  • FV function: Description, Usage, Syntax, Examples and Explanation
  • IPMT function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate compound interest in Excel
  • Calculate cumulative loan interest in Excel
  • Calculate payment for a loan in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles