Use

The Floor() function returns the next lower multiple, rounding down towards negative infinity.

The default multiple is 1, but the optional second input specifies a multiple to be rounded to. E.g. Floor(5.4, 0.25) = 5.25. The multiple is expected to be unitless.

Units

Numbers with units will be rounded based on those units. This means that the unit a number has at the point of calculation will affect the answer.

For example, Floor(5.8ft) to mm and Floor(5.8 ft to mm) will return values that are not equal.

Examples

• Floor(1.8)  = 1
• Floor(1.8, 0.4)  = 1.6
• Floor(1.2)  = 1
• Floor(-1.8)  = -2
• Floor(3.2 ft)  = 3ft
• Floor(3.2 ft) to mm  = 914.4 mm
• Floor(3.2 ft to mm)  = 975 mm
• Floor(5.33 ft, 0.25) to ft  = 5.25 ft
• Floor(5.33 ft to ft in, 0.25)  = 5 ft 3.75 in

---

Function

Floor(value) value Floor(value, multiple) value multiple

---