I. SUM
SUM(number1,number2,...): Find the sum of all numbers in a specified cell range.
number1,number2,...: 1 to n parameters or all numbers in the specified cell range.
Note: The function will directly enter the numerical value, logical value and text expression in the parameter. If the parameter is an array or reference, only the value in the array or cell reference is calculated.
Example:
SUM(70,80) is equal to 150.
SUM("70",80,TRUE) is equal to 151, the logical value "TRUE" is calculated as 1; "FALSE" is calculated as 0; the text "70" is calculated as 70.
Enter =sum(A1,B3,D5) in the cell to return the sum of all numbers expanded from cells A1, B3, and D5.
Enter =sum(A1:B3) in the cell to return the sum of all numbers expanded from the cells in the range A1 to B3.
II. /
1)/
Directly divide by /, enter =5/3 in the cell, and the return value is 1.6666...7.
2)%
Use % to calculate the remainder, enter =5%3 in the cell, and the return value is 2.
3) MOD()
MOD (number, divisor): returns the remainder of the division of two numbers. The sign of the result is the same as the divisor.
number: is the dividend.
divisor: Divisor.
Example:
MOD(3,2) is equal to 1.
MOD(-3,2) is equal to 1.
MOD(3,-2) is equal to -1.
MOD(-3,-2) is equal to -1.
III. MAX
MAX(number1,number2,...): Returns the maximum value in the parameter list.
Number1,number2,...: 1 to n parameters whose maximum value needs to be found.
Note: The parameters can be numbers, blank cells, logical values or numeric text expressions. If the array or reference parameter contains resolvable text values, logical values, zero values or blank cells, these values will participate in the calculation, and unresolvable text values are ignored. If there is no number in the parameter, MAX will return 0.
Example:
MAX(0.1,0,1.2) is equal to 1.2.
IV. MIN
MIN(number1,number2,...): Returns the minimum value in the parameter list.
Number1,number2,...: 1 to n parameters whose minimum value needs to be found.
Note: If there is no number in the parameter, the function MIN will return 0. The parameter should be a number, a blank cell, a logical value, or a text string representing a value. If the parameter is an error value, MIN will return an error message. If the array or reference parameter contains resolvable text values, logical values, zero values or blank cells, these values will participate in the calculation, and unresolvable text values are ignored.
Example:
If B1:B4 contains 3, 6, 9, 12, then MIN(B1:B4) is equal to 3, and MIN(B1:B4,0) is equal to 0.
V. ROUND
ROUND(number,num_digits): returns a number after rounding a specified number of digits.
number: The number to be rounded.
num_digits: The specified number of digits, according to this number of digits for rounding. If num_digits is greater than 0, it is rounded to the specified decimal place. If num_digits is equal to 0, then round to the nearest integer. If num_digits is less than 0, it is rounded to the left of the decimal point.
Note: Due to the loss of precision calculation of floating-point numbers, the calculation results may contain 9999,0000. Therefore, a third parameter is added to control whether 9999 needs to be removed. True means that the data of 9999,0000 needs to be filtered.
Example:
ROUND(2.15,1) is equal to 2.2.
ROUND(2.149,1) is equal to 2.1.
ROUND(-1.475,2) is equal to -1.48.
ROUND(21.5,-1) is equal to 20.
Enter =round(12.49,0) in the cell. Since the value after the number of digits to be rounded is 4 is less than 5, the return value is 12.
Enter =round(12.49,1) in the cell. Since the value after the number of digits to be rounded is 9 greater than 5, the return value is 12.5.
VI. TRUNC
TRUNC(number,num_digits): Truncates the decimal part of the number and returns an integer.
number: The number that needs to be truncated.
num_digits: The number used to specify the rounding precision.
Example:
TRUNC(8.9) is equal to 8.
TRUNC(-8.9) is equal to -8.
TRUNC(PI()) is equal to 3.
Enter =trunc(4.8) in the cell, and the return value is 4.