Filter
Top Products
Using mathematical functions 10-15
Real-number functions
Some real-number functions can also take complex
arguments.
CEILING Smallest integer greater than or equal to value.
CEILING(value)
Examples
CEILING(3.2) returns 4
CEILING(-3.2) returns -3
DEG→RAD Degrees to radians. Converts value from Degrees angle
format to Radians angle format.
DEG→RAD(value)
Example
DEG→RAD(180) returns 3.14159265359, the
value of π.
FLOOR Greatest integer less than or equal to value.
FLOOR(value)
Example
FLOOR(-3.2) returns -4
FNROOT Function root-finder (like the Solve aplet). Finds the value for
the given variable at which expression most nearly evaluates
to zero. Uses guess as initial estimate.
FNROOT(expression, variable, guess)
Example
FNROOT(M*9.8/600-1,M,1) returns
61.2244897959.
FRAC Fractional part.
FRAC(value)
Example
FRAC (23.2) returns .2