The PRODUCT function returns the product of two or more numbers. For example, this returns 24, since 3 x 8 = 24.
The PRODUCT function can also handle three or more numbers. For example, this returns 96, since 3 x 8 x 4 = 96.
You can also use PRODUCT to multiply the contents of a range of cells. For example, if you have the numbers 1, 2, 3, and 4 in cells A1, A2, A3, and A4, respectively, then the formula will return 24, since 1 x 2 x 3 x 4 = 24.
=PRODUCT(A1:A4, 6, 8)
You can also use PRODUCT to multiply a mix of numbers and cell ranges. For example, this will return 1152, since 1 x 2 x 3 x 4 x 6 x 8 = 1152.
=PRODUCT(A1, B2, 8, 10)
You can also use PRODUCT to multiply a mix of numbers and cell references. For example, this will return the product of the contents of cells A1 and B2 with the numbers 8 and 10. If A1 contains 2 and B2 contains 3, the the result will be 480, since 2 x 3 x 8 x 10 = 480.
The PRODUCT function is a useful tool for multiplying numbers together. It takes multiple arguments, such as constants, cell references or ranges, and multiplies them all together, ignoring empty cells and text.