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!

Rounding numbers

Rounding the numbers in Excel is done automatically. Nevertheless, there is sometimes a need to influence how the rounding is done. This is crucial when we create reports with data expressed in thousands or millions, when decimals represent significant amounts of money. We can do this by adjusting rounding based on how the number is displayed or using rounding numbers.