If num_digits is positive, the quantity is truncated to the specified variety of digits to the best of the decimal point. The FLOOR operate in Excel is used to spherical a given number down, to the nearest a quantity of of a specified significance. The MROUND operate in Excel rounds a given quantity up or right down to the required.. Read more