Filter
Top Products
Functions and commands 313
Math menu
Press D to open the
Toolbox menus (one of which
is the Math menu). The
functions and commands
available on the Math menu
are listed as they are
categorized on the menu.
Numbers
Ceiling Smallest integer greater than or equal to value.
CEILING(value)
Examples:
CEILING(3.2) returns 4
CEILING(-3.2)
returns -3
Floor Greatest integer less than or equal to value.
FLOOR(value)
Example:
FLOOR(3.2) returns 3
FLOOR(-3.2)
returns -4
IP Integer part.
IP(value)
Example:
IP(23.2) returns 23
FP Fractional part.
FP(value)
Example:
FP (23.2) returns .2
Round Rounds value to decimal places. Also accepts complex
numbers.
ROUND(value,places)