Loading ...
Loading ...
Loading ...
96
MAX(values...) Returns the largest value in the
argument list.
Example: MAX(12, 29, 8, -39) returns
29.
MIN (values...) Returns the smallest value in the
argument list.
Example: MIN(-5, 29, 32, 7) returns
-5.
STDEVP(values...)
Calculates standard deviation of the
population as given.
Example: STDEVP(45, 68, 22, 70,
50, 39) returns 16.5731.
VARP(values...) Calculates the variance of the
population as given.
Example: VARP(45, 68, 22, 70, 50,
39) returns 274.67.
NOTE
Blank cells in the argument range of these functions are
ignored: MIN, MAX, STDEVP, VARP and AVERAGE.
Trigonometric functions
Trigonometric functions operate on numeric values or
references to numeric values. The angle values are
generally expressed in radians.
ACOS(value) Returns the arccosine of a value. The
value cannot be less than -1 or
greater than 1.
Example: ACOS(-0.5) returns 2.094.
ASIN(value) Returns the arcsine of a value. The
value cannot be less than -1 or
greater than 1.
Example: ASIN(-0.5) returns -0.524.
ATAN(value) Returns the arctangent of a value. The
returned value is in the range -π/2 to
π/2.
Example: ATAN(1) returns 0.785.
ATAN2(xvalue, yvalue)
Returns the arctangent of yvalue
divided by xvalue. The returned value
is in the range -π to π.
Example: ATAN2(3,1) returns 0.322.
Loading ...
Loading ...
Loading ...