PRODUCT( ), FACT( ), POWER( ), and SQRT( ): Products, Factorials, Powers, and Square Roots
PRODUCT( ), FACT( ), POWER( ), and SQRT( ): Products, Factorials, Powers, and Square Roots These four functions actually offer the same services provided by many of the simple operators covered in the last chapter, but, in some cases, they come with a few twists that may save you time. The PRODUCT( ) function takes a list of numbers, multiplies them together, and gives the result. For example, the following formula multiplies 2*3*3, and arrives at 18: =PRODUCT(2,3,3) One interesting characteristic of the PRODUCT( ) function is that in addition to accepting individual cell references, it also supports cell ranges . You can use PRODUCT( ) to multiply all the numbers in a range in the same way you use SUM( ) to add numbers. Here's an example: =PRODUCT(A2:A12) You can use the FACT( ) function to calculate a factorial , which is a sequence of numbers (starting at 1), each of which is multiplied together to arrive at the result. For example, 5! (pronounc