Math functions in Excel
INT: function rounding down to the nearest integer
Syntax: INT (number)
Example: INT (2.6) = 2
ABS: absolute value calculation
Syntax ABS (number)
Example: ABS (3) = 3, ABS (-3) = 3
MOD function: function divide the balance
Syntax: MOD (Number, Divisor)
For example: MOD (5,2) = 1. Explanation 5 1 2 divided by 2 balance
SUM: sum function
Syntax: SUM (number1, number2, ...)
For example: SUM (5,2,1) = 8
ROUND function: function round
Syntax: ROUND (number, NUM_DIGITS)
Example: ROUND (6.36,1) = 6.4
MAX: function is the biggest
Syntax: MAX (number1, number2, ...)
Example: MAX (6,2,7,9) = 9
AVERAGE: The average value calculation function
Syntax: AVERAGE (Number1, number2 ...)
Example: AVERAGE (4,6,8) = 6. Interpretation (4 + 6 + 8) / 3 = 6
List of chain function group
LEFT: take the character to the left
Syntax: LEFT (Text, NUM_CHARS)
Signs: take the number of characters from the left
For example: LEFT ( "Royal", 2) = Ho. Explain to this function it will take two letters of the word Royal and returned to you as ho
