ExcelCSE.com

Menu
  • Excel 101
  • Excel Functions
  • Excel Formula
  • Contact Us
How to Use Excel > Excel Functions > Excel PRODUCT Function

Excel PRODUCT Function

How to Use the Excel PRODUCT Function
Table of contents :
  • What is the Excel PRODUCT Function?
  • PRODUCT Syntax
  • How to Use PRODUCT Function in Excel
  • PRODUCT Example

Excel PRODUCT Function

What is the Excel PRODUCT Function?

What does product mean in math? In mathematics, a product is a result of multiplying. The Excel PRODUCT function is an Excel function that multiplies all the numbers in the argument.

The PRODUCT function results are similar to a multiplication formula using the asterisk “*” sign, but the PRODUCT function is more useful if you want to multiply in large numbers.

PRODUCT Syntax

PRODUCT(number1, [number2], ...)

number1, required, number or range to be multiplied.

number2, optional, other numbers or ranges to be multiplied, maximum 255 numbers or ranges.

Usage Notes:

  • Only numbers are multiplied.
  • Empty cells, logical values, and text are ignored.

How to Use PRODUCT Function in Excel

For example, there is data as shown below. What is the result of the PRODUCT function that uses data in columns A to E as the number argument?

Excel PRODUCT Formula

PRODUCT Function #1

=PRODUCT(A1:D1)

The result is the multiplication of the four numbers in the range A1:D1.

The result is 24

PRODUCT Function #2

=PRODUCT(A2:D2)

A result is a negative number because there is a negative number in range A2:D2.

The result is -24

PRODUCT Function #3

=PRODUCT(A3:D3)

Even though there is a negative number, the result of the PRODUCT function can be a positive number if the number of negative numbers is even.

The result is 24.

PRODUCT Function #4

=PRODUCT(A4:D4)

If there is an alphanumeric data, the PRODUCT function does not attempt to convert it to numbers but ignores it. So only numbers in cell A4, C4 and D4 are multiplied.

The result is 12.

PRODUCT Function #5

=PRODUCT(A5:D5)

In addition to text, logical values are also ignored by the PRODUCT function. In this case, the results are different if you multiply using the asterisk “*” sign because TRUE/FALSE will be converted to number 1/0 if involved in mathematical operations (addition/multiplication).

Excel only multiply the number in cell A5 and D5. The result is 4.

Please see the complete results of the excel PRODUCT function in column E in the image below.

PRODUCT Formula

PRODUCT Example

Another article using or explain about PRODUCT Function
  • How to Do Multiplication in Excel

Another Math Function

Another article about Math Function
  • Excel SUBTOTAL Function
  • Excel AGGREGATE Function
  • Excel PRODUCT Function
  • Excel CONVERT Function
  • Excel SUMIFS Function
  • Excel SUMIF Function
  • Excel SUM Function
  • Excel SUMPRODUCT Function
  • Excel QUOTIENT Function
  • Excel MOD Function
Share
Tweet
Google+
Email
Prev Article
Next Article

Related Articles

Excel LEFT Function
What is the Excel LEFT Function? The excel LEFT function …

Excel LEFT Function

Excel INT Function
What is the Excel INT Function? The excel INT function …

Excel INT Function

INDEX MATCH Excel
INDEX MATCH Formula You can use the INDEX function and …

INDEX MATCH – Excel VLOOKUP Alternative

Excel REPT Function
What is the Excel REPT Function? The excel REPT function …

Excel REPT Function

Excel AVERAGE Function
What is the Excel AVERAGE Function? The Excel AVERAGE function …

Excel AVERAGE Function

Tags:Does Product Mean Multiply Excel PRODUCT Excel PRODUCT Formula Is Product Multiplication Math Function PRODUCT Formula Product Meaning in Math Product Means Multiply Product of Functions Product of Two Numbers What Does Product Mean in Math What is Product in Multiplication What is The Product of Two Numbers

Categories

  • Excel 101
  • Excel Formula
  • Excel Functions

Recent Posts

  • Get the Original Price from Percentage Increase/Decrease
  • How to Add/Subtract Percentage in Excel
  • How to Extract Day, Month and Year from Date in Excel
  • How to Add Seconds, Minutes and Hours to a Time in Excel
  • How to Add Days, Weeks, Months and Years to a Date in Excel
  • How to Calculate Time Difference in Excel
  • Calculate Number of Days, Weeks, Months and Years Between Two Dates in Excel
  • Flash Fill Excel
  • Paste Special Excel
  • Excel TEXTJOIN Function
  • Excel CONCAT Function
  • Excel CONCATENATE Function
  • Excel REPLACE Function
  • Excel SUBSTITUTE Function
  • Excel REPT Function
  • Excel FIND Function
  • Excel SEARCH Function
  • Excel MID Function
  • Excel RIGHT Function
  • Excel LEFT Function

ExcelCSE.com

The Ultimate Guide How to Use Excel Better
Copyright © 2023 ExcelCSE.com
Contact Us - Privacy Policy - Sitemap | Theme by MyThemeShop.com

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh