What is a rounding up function?
Rounding up function is a common mathematical function, usually expressed as ceil(x), which is used to round up a real number X, that is, the smallest integer not less than X. The result of rounding up a positive integer is itself, and the error rate for negative numbers will be greater.
Rounding function symbol
In mathematical symbols, the upward integer function is usually expressed as "? x？” , or "ceiling (x)".
How to determine the function range of rounding?
When rounding up, you need to determine the rounding range. For example, if we round up 5.45 and -3. 12, we will get the following results:? 5.45? =6, ? -3. 12? =-3。 Therefore, the rounding range of the rounding function is: the rounding range of positive numbers is the smallest integer larger than the original number, and the rounding range of negative numbers is the largest integer smaller than the original number.
Excel formula above integer
Roundup function can be used for rounding in excel. The formula is rounding (the value needs to be rounded to the nearest integer).
What is excel?
Microsoft Excel is a spreadsheet software written by Microsoft for computers using Windows and AppleMacintosh operating systems. Intuitive interface, excellent calculation function and chart tools, coupled with successful marketing, make Excel the most popular personal computer data processing software.
1993, as a component of MicrosoftOffice, after the release of version 5.0, Excel began to become the overlord of spreadsheet software on the applicable operating platform.