What is the purpose of the Floor() function in Quick Base?

The Floor() function in Quick Base is designed to return the highest integer that is less than or equal to a specified number. This means that if you input a decimal number into the Floor() function, it will round the number down to the nearest whole number, effectively removing the decimal component without going higher than the original value. For instance, if you were to input 3.7 into the Floor() function, it would return 3, as this is the highest whole number that does not exceed 3.7.

Understanding this function is crucial for scenarios where you need to work with whole numbers and avoid rounding up, which is particularly useful in financial calculations, data analysis, or when dealing with quantities that cannot exceed certain limits. This is what differentiates it from functions that round numbers up or down in different ways.