EXCEL Processing of numbers in , Often round by the specified number of digits as needed .
Rounding of numbers can be done with the following functions ：
Rounding =ROUND(A1,0)
Truncate decimals and round =ROUNDDOWN(A1,0) =FLOOR(A1,1) =TRUNC(A1)
Truncate the decimal to the nearest even number =EVEN(A1)
Truncate decimals and take integers upward =CEILING(A1,1)
Truncate decimals and round down =INT(A1)
C Languages have the following rounding methods ：
1, Direct assignment to integer variables . as ：
int i = 2.5; or i = (int) 2.5;
This method uses rounding off the decimal part
2,C/C++ Integer division operator in “/” It has rounding function (int / int), However, the integer division of negative numbers and the use of rounding results C Compiler related .
3, use floor function .floor(x) Returns less than or equal to x Maximum integer of . as ：
floor(2.5) = 2
floor(-2.5) = -3
4, use ceil function .ceil(x) Returned is greater than x Minimum integer of . as ：
ceil(2.5) = 3
ceil(-2.5) = -2
floor() Is rounded to negative infinity ,floor(-2.5) = -3;ceil() Is rounded to positive infinity ,ceil(-2.5) = -2.
MATLAB There are many rounding functions in , List its usage for convenience in the future ：
floor
B = floor(A) Return less than or equal to A Integer value of , For the plural , Respectively A Real part and imaginary part of .
a = [-1.9, -0.2, 3.4, 5.6, 7.0, 2.4+3.6i]
a =
Columns 1 through 6
-1.9000 -0.2000 3.4000 5.6000 7.0000 2.4000 + 3.6000i
floor(a)
ans =
Columns 1 through 6
-2.0000 -1.0000 3.0000 5.0000 7.0000 2.0000 + 3.0000i
ceil
B = ceil(A) Return greater than or equal to A Integer value of , For the plural , Respectively A Real part and imaginary part of .
a = [-1.9, -0.2, 3.4, 5.6, 7, 2.4+3.6i]
a =
Columns 1 through 6
-1.9000 -0.2000 3.4000 5.6000 7.0000 2.4000 + 3.6000i
ceil(a)
ans =
Columns 1 through 6
-1.0000 0 4.0000 6.0000 7.0000 3.0000 + 4.0000i
round:
Y = round(X) Return distance X Nearest integer value .
a = [-1.9, -0.2, 3.4, 5.6, 7.0, 2.4+3.6i]
a =
Columns 1 through 4
-1.9000 -0.2000 3.4000 5.6000 7.0000 2.4000 + 3.6000i
round(a)
ans =
Columns 1 through 4
-2.0000 0 3.0000 6.0000 7.0000 2.0000 + 4.0000i
fix：
B = fix(A) return A Integer part of , The decimal part is 0
a = [-1.9, -0.2, 3.4, 5.6, 7.0, 2.4+3.6i]
a =
Columns 1 through 4
-1.9000 -0.2000 3.4000 5.6000 7.0000 2.4000 + 3.6000i
fix(a)
ans =
Columns 1 through 4
-1.0000 0 3.0000 5.0000 7.0000 2.0000 + 3.0000i
Technology