Filter
Top Products
11-14 Using mathematical functions
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
HMS→ Hours-minutes-seconds to decimal. Converts a number or
expression in H.MMSSs format (time or angle that can
include fractions of a second) to x.x format (number of
hours or degrees with a decimal fraction).
HMS→(H.MMSSs)
Example
HMS→(8.30) returns 8.5
→HMS Decimal to hours-minutes-seconds. Converts a number or
expression in x.x format (number of hours or degrees
with a decimal fraction) to H.MMSSs format (time or
angle up to fractions of a second).
→HMS(x.x)
Example
→HMS(8.5) returns 8.3
INT Integer part.
INT(value)
Example
INT(23.2) returns 23
MANT Mantissa (significant digits) of value.
MANT(value)
Example
MANT(21.2E34) returns 2.12