Formulas and Functions

“Listing of Numeric Functions” on page 167
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
FLOOR
The FLOOR function rounds a number toward zero to the nearest multiple of the
specied factor.
FLOOR(num-to-round, factor)
 num-to-round: The number to be rounded. num-to-round is a number value.
 factor: The number to use to determine the closet multiple. factor is a number
value. It must have the same sign as num-to-round.
Examples
=FLOOR(0.25, 1) returns 0.
=FLOOR(1.25, 1) returns 1.
=FLOOR(5, 2) returns 4.
=FLOOR(73, 10) returns 70.
=FLOOR(-0.25, -1) returns 0.
=FLOOR(9, 2.5) returns 7.5.
Related Topics
For related functions and additional information, see:
“CEILING” on page 170
“EVEN” on page 173
“INT” on page 17 8
“MROUND” on page 183
“ODD” on page 185
“ROUND” on page 191
“ROUNDDOWN” on page 192
“ROUNDUP” on page 193
17 6 Chapter 8 Numeric Functions