Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Randomize/ Shuffle List in Excel
  • Subtotal function in Excel
  • How to add Trendline to a chart in Excel
  • How to Create Gantt Chart in Excel
  • Excel Pie Chart

References

  • How to get last row in mixed data with blanks in Excel
  • How to use Excel FORMULATEXT function
  • How to use Excel MATCH Function
  • Count rows that contain specific values in Excel
  • Excel Advanced Lookup using Index and Match Functions

Data Validations

  • Excel Data validation number multiple 100
  • Excel Data validation must contain specific text
  • Excel Data validation must begin with
  • Excel Data validation unique values only
  • Excel Data validation with conditional list

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:   Dynamic Named Range 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 percentage of total 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 calculate number of Days until Birthday

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:

Lock Cells in a Worksheet 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

Logical Functions

  • How to return blank in place of #DIV/0! error in Excel
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • OR function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel TRUE Function

Date Time

  • Steps to create Dynamic calendar grid in Excel
  • Count holidays between two dates in Excel
  • Custom weekday abbreviation in Excel
  • EDATE function: Description, Usage, Syntax, Examples and Explanation
  • Count times in a specific range in Excel

Grouping

  • Group numbers with VLOOKUP in Excel
  • Group arbitrary text values in Excel
  • Map inputs to arbitrary values in Excel
  • Group times into 3 hour buckets in Excel
  • Calculate conditional mode with criteria in Excel

General

  • Convert column number to letter in Excel
  • Using Existing Templates in Excel
  • 231 Keyboard Shortcut Keys In Excel
  • Currency vs Accounting Format in Excel
  • Find, Select, Replace and Go To Special in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning