Formulas and Functions

“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
SQRTPI
The SQRTPI function returns the square root of a number after it has been multiplied
by π (pi).
SQRTPI(non-neg-number)
 non-neg-number: A nonnegative number. non-neg-num is a number value and
must be greater than or equal to 0.
Examples
=SQRTPI(5) returns 3.96332729760601.
=SQRTPI(8) returns 5.013256549262.
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
SUM
The SUM function returns the sum of a collection of numbers.
SUM(num-date-dur, num-date-dur…)
 num-date-dur: A value. num-date-dur is a number value, a date/time value, or a
duration value.
 num-date-dur…:Optionally include one or more additional values. If more than
one num-date-dur value is specied, they must all be of the same type.
Usage Notes
There is one case where all values do not have to be of the same type. If exactly one Â
date/time value is included, any number values are considered to be numbers of
days and all numbers and duration values are added to the date/time value.
19 6 Chapter 8 Numeric Functions