function:FLOOR
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| function:FLOOR [2023/09/20 04:15] – peternlewis | function:FLOOR [2023/09/20 08:41] (current) – peternlewis | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== FLOOR Function ====== | ====== FLOOR Function ====== | ||
| - | The FLOOR() function takes a number and returns the first integer that is less than or equal to the argument: | + | The FLOOR(x) function takes a number and returns the first integer that is less than or equal to the argument: |
| FLOOR(5.5) === FLOOR(5.1) === FLOOR(5) === 5 | FLOOR(5.5) === FLOOR(5.1) === FLOOR(5) === 5 | ||
| FLOOR(-5.5) === FLOOR(-5.1) === FLOOR(-6) === -6 | FLOOR(-5.5) === FLOOR(-5.1) === FLOOR(-6) === -6 | ||
| + | |||
| + | The FLOOR() function (v11.0+) takes a second optional parameter to indicate the number of decimal digits to operate to: | ||
| + | |||
| + | FLOOR(5.6789, | ||
| + | FLOOR(-5.6789, | ||
| ===== See Also ===== | ===== See Also ===== | ||
function/FLOOR.1695183355.txt.gz · Last modified: by peternlewis