Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelPRODUCT Function in Excel

# 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.

The following examples has arguments taken as a group

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

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

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