FLOOR Function

Rounds a number toward zero to the nearest specified multiple of significance
Sample Usage
FLOOR([Price Per Unit]1, 2)
Syntax
FLOOR(
  • number
  • [
    multiple
    ]
)
  • number
    The number to round down
  • multiple
    —[optional]
    The nearest multiple of significance in which to round
Examples

Still need help? 

Use the Smartsheet Formula Template to view examples and practice working with functions in real-time. 


Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.

Ask the Community