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

Lookup and Reference Examples

  • How to get last row in numeric data in Excel
  • How to get relative row numbers in a range in Excel
  • Count rows with at least n matching values
  • Extract all partial matches in Excel
  • How to get last column number in range in Excel

Data Analysis Examples

  • What-If Analysis: Scenarios and Goal Seek in Excel
  • How to create a Histogram in Excel
  • Everything about Charts in Excel
  • Conditional Formatting Icon Sets Examples in Excel
  • Conditional Formatting Rules in Excel

Data Validation Examples

  • Data validation must not exist in list
  • How To Create Drop-down List in Excel
  • Excel Data validation with conditional list
  • Excel Data validation no punctuation
  • Excel Data validation date in specific year

PRODUCT function: Description, Usage, Syntax, Examples and Explanation

by

What is PRODUCT function in Excel?

PRODUCT function is one of the Math and Trig functions in Microsoft Excel that 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, A2) to multiply those two numbers together. You can also perform the same operation by using the multiply (*) mathematical operator; for example, =A1 * A2.

The PRODUCT function is useful when you need to multiply many cells together. For example, the formula =PRODUCT(A1:A3, C1:C3) is equivalent to =A1 * A2 * A3 * C1 * C2 * C3.

Syntax of PRODUCT function

PRODUCT(number1, [number2], …)

The PRODUCT function syntax has the following arguments:

  • number1: The first number or range that you want to multiply.
  • number2(Optional): Additional numbers or ranges that you want to multiply, up to a maximum of 255 arguments.

Note: If an argument is an array or reference, only numbers in the array or reference are multiplied. Empty cells, logical values, and text in the array or reference are ignored.

Example of PRODUCT function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

Data
5
15
30
Formula Description Result
=PRODUCT(A2:A4) Multiplies the numbers in cells A2 through A4. 2250
=PRODUCT(A2:A4, 2) Multiplies the numbers in cells A2 through A4, and then multiplies that result by 2. 4500
=A2*A3*A4 Multiplies the numbers in cells A2 through A4 by using mathematical operators instead of the PRODUCT function. 2250

Post navigation

Previous Post:

QUOTIENT function: Description, Usage, Syntax, Examples and Explanation

Next Post:

POWER function: Description, Usage, Syntax, Examples and Explanation

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
  • TEXTJOIN function: Description, Usage, Syntax, Examples and Explanation
  • CLEAN function: Description, Usage, Syntax, Examples and Explanation
  • Remove line breaks in a cell in Excel
  • CONCAT function: Description, Usage, Syntax, Examples and Explanation
  • Remove text by variable position in a cell in Excel
  • Add workdays to date custom weekends in Excel
  • How to get year from date in Excel
  • How to calculate nth day of week in month in Excel
  • Get day name from date in Excel
  • HOUR function: Description, Usage, Syntax, Examples and Explanation
  • Calculate payment for a loan in Excel
  • ACCRINT function: Description, Usage, Syntax, Examples and Explanation
  • NPV function: Description, Usage, Syntax, Examples and Explanation
  • TBILLPRICE function: Description, Usage, Syntax, Examples and Explanation
  • PMT, RATE, NPER, PV and FV Financial Functions in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles