PRODUCT
Formulas / PRODUCTMultiply numbers given as arguments.
=PRODUCT(number1,[number2],...)
- number1 - required argument that is the first number or range to multiply
- number2 - [OPTIONAL] second number or range to multiply
Examples
=PRODUCT(3,8)The PRODUCT function returns the product of two or more numbers. For example, this returns 24, since 3 x 8 = 24.
=PRODUCT(3,8,4)The PRODUCT function can also handle three or more numbers. For example, this returns 96, since 3 x 8 x 4 = 96.
=PRODUCT(A1:A4)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.
Summary
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.
- The PRODUCT function takes up to 255 arguments which can be hardcoded constants, cell references, or ranges.
- The arguments are multiplied together, though empty cells and text values are not ignored.
- PRODUCT ignores text and empty cells in the argument.
Frequently Asked Questions
What is the PRODUCT function in Sourcetable?
What types of arguments can the PRODUCT function take?
How does the PRODUCT function handle empty cells and text values?
What are some uses of the PRODUCT function?
- Multiply numbers in a range
- Multiply hardcoded constants
- Multiply cell references
