beautypg.com

Product, 187 product – Apple iWork '09 User Manual

Page 187

background image

Chapter 8

Numeric Functions

187

Examples

=POWER(2, 3) returns 8.
=POWER(2, 10) returns 1024.
=POWER(0.5, 3) returns 0.125.
=POWER(100, 0.5) returns 10.

Related Topics
For related functions and additional information, see:

“Listing of Numeric Functions” on page 167

Value Types” on page 36

The Elements of Formulas” on page 15

“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26

“Pasting from Examples in Help” on page 41

PRODUCT

The PRODUCT function returns the product of one or more numbers.

PRODUCT(num-value, num-value…)

Â

num-value: A number. num-value is a number value.

Â

num-value…:  Optionally include one or more additional numbers.

Usage Notes

Empty cells included within the values are ignored and do not affect the result.

Â

Examples

=PRODUCT(2, 4) returns 8.
=PRODUCT(0.5, 5, 4, 5) returns 50.

Related Topics
For related functions and additional information, see:

“SUM” on page 196

“Listing of Numeric Functions” on page 167

Value Types” on page 36

The Elements of Formulas” on page 15