Microsoft Tech Community - Latest Blogs - Excel Blog

السبت، 20 أغسطس 2022

The ROUND function allows you to round your results to a set number of decimal places.

 



The ROUND function allows you to round your results to a set number of decimal places.

When we perform calculations, often the result is displayed to a level of precision beyond our needs.


To ensure that a result is only ever displayed to a set level of decimal precision, we can enclose the calculation in a ROUND function and define the number of decimal places, such as 2 decimal places…

…or rounded to a whole number.

A lesser-known ability of the ROUND function is that you can round UP in a “left of the decimal” fashion.  This is useful when you are representing very large numbers, but you only need precision to a certain level.

ليست هناك تعليقات:

إرسال تعليق