PRODUCT Function in Excel

In this post, you will learn about a mathematical function in Excel – the PRODUCT Function, how to use it in your excel spreadsheets.

How to use PRODUCT Function in Excel?

Syntax

=PRODUCT(number 1, number 2, ...)

The syntax initially has two arguments

  • number 1 – This argument holds the first number.
  • number 2 – This argument holds the second number.

This function returns the product of the numbers given as arguments, this function is useful when multiplying many cells together.

  • When including the arguments in the Product function they can be
    – directly inserted ; =PRODUCT(2, 4,..)
    – inserted individually as cells or; =PRODUCT(A1, A2, A3,..)
    – inserted collectively as a group; =PRODUCT(A1: A4)

The following examples shows the different ways the function can be used.

How to use PRODUCT Function in Excel?
How to use PRODUCT Function in Excel?

The following examples has arguments taken as a group

How to use PRODUCT Function in Excel?
How to use PRODUCT Function in Excel?
How to use PRODUCT Function in Excel?

After the function is implemented, use the fill handle to apply the formula to the rest of the function.

How to use PRODUCT Function in Excel?

Leave A Reply

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

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021