| Examples |
| CEILING(3.2) returns 4 |
| |
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 |
| |
FNROOT | Function |
| for the given variable at which expression most nearly |
| evaluates to zero. Uses guess as initial estimate. |
| FNROOT(expression, variable, guess) |
| Example |
| |
| 61.2244897959. |
FRAC | Fractional part. |
| FRAC(value) |
| Example |
| FRAC (23.2) returns .2 |
HMS→ | |
| 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 |
| expression in x.x format (number of hours or degrees |
Using mathematical functions |