Rounding for merchants

Rounding functions are approximating numbers to higher or lower values. On that occasion, they are guided by mathematical principles. However, when pricing is often required, rounding is done at a higher or lower level according to a given degree of significance, which is the decimal number in relation to which the rounding is done. Dear merchants (and everyone else), we present you functions FLOOR and CEILING!

The CEILING function makes rounding the number up to a certain degree of significance. Its syntax:

CEILING(<number>,<degree of significance>)

For example, if you enter the formula in cell E3:

=CEILING (C3,0.05)

the specified function will round the value in cell C3 to a number that is closer to the upper value rounded to 0.05. In this way, the number 100.345 becomes 100.35.

The FLOOR function has the same syntax as the previously mentioned function:

FLOOR(<number>,<degree of significance>)

It makes rounding to a lower number, for a given degree of significance. Thus, if we enter the formula in function D3:

=FLOOR (C3,0.05)

it returns number 100.345, which is the content of cell C3, will be rounded to 100.30.

There are two other variants of these functions: CEILING.MATH and FLOOR.MATH. They allow, if we omit the degree of significance, automatic rounding to a lower or higher whole number. They have another additional argument, whose guidance specifies the way it rounds negative numbers (to zero or zero).