Use the FLOOR function to round down values to the nearest 100
As seen in our previous article, it is easy to round up values to multiples of 100. To round numbers down to the nearest multiple of significance, use the FLOOR function. Here is the syntax that is used:
FLOOR(number, significance)
number: The value to be rounded.
significance: The multiple to which the number will be rounded down.
To round [...]
