Examples

 

CEILING(3.2) returns 4

 

CEILING(-3.2) returns -3

DEGRAD

Degrees to radians. Converts value from Degrees angle

 

format to Radians angle format.

 

DEGRAD(value)

 

Example

 

DEGRAD(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

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

13-14

Using mathematical functions