FLOORAT (Array,MaxNumber)
- is the set of values.
- is the maximum number.
Description
- This function rounds the number down to the nearest integer or to its nearest multiple of significance.
- In , is the value to be rounded down.Significance is the multiple which want to round down.If the Number is the positive numbers with decimal portions are rounded down to the nearest integer.For example,12.43 is rounded down to 12. If the Number is the negative numbers with decimal portions are rounded away and also the given number is negative number and significance should be a negative number.The Significance argument rounds the number down to the nearest integer that is a multiple of the significance specified. The exception is where the number to be rounded is an integer.If Number divided by a Significance of 2 or greater results in a remainder, the result is rounded down.