174 Using mathematical functions
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 app). 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.224489796.
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