How to use Excel to complete a function

How to use Excel to complete a function

The INT function can be used to intercept a decimal number by simply preserving the integer part. Using the method, you can A1 the A1 cell by simply entering the formula "=int" in the cell.

The floor function is used to round up a decimal number down a given base, and it is also used to implement the rounding operation. Note that the cardinality should be set to "1" when used.

As shown in the specific use method:

The ceiling function can also be used for rounding operations, which can be rounded up by the specified cardinality. After taking the whole, some processing is needed, when the decimal part is not 0 o'clock, it is necessary to reduce the 1 processing.

The specific use of the method as shown in the figure: