Buzz
Compilation of commonly used calculation functions in Excel designed for accounting professionals.
1. ABS Function
- Syntax: ABS(number).
+ Number in the syntax represents a numerical value, which can be a parameter, reference, or expression with a value.
- Function Meaning: Returns the absolute value of a number.
- Example: abs(-5) = 5; abs(5) = 5
2. Power Function
- Syntax: power(number, power)
Where:
+ Number represents a real number.
+ Power refers to the exponent (or the number raised to the power).
- Meaning of the function: It performs exponentiation.
- Example:
4. Function Product
- Syntax: Product(number1, number2, …).
Where:
+ Number 1 represents the first factor.
+ Number 2 represents the second factor, and so on.
+ Can contain up to 255 number arguments.
- Function Meaning: Calculates the product of a series of numbers.
- Example:
5. Mod Function
- Syntax: Mod(number, divisor).
Where:
+ Number: is the divisor.
+ Divisor: is the dividend.
+ If the divisor = 0, the return value is False.
- The function returns the remainder of the division (the remainder carries the sign of the divisor).
- Example:
6. Hàm roundup
- Meaning: is a function for rounding decimal numbers.
- Syntax: roundup(number, Num_digits).
Where:
+ Number represents the number to round.
+ Num_digist is the number of digits to round up. Based on Num_digits, the rounding rule is determined.
- Example:
+ round(2.45, 0) = 5
+ round(2.45, 1) = 2.5
+ round(2.45, -1) = 10
6. Even Function
- Syntax: Even(number).
+ Where number represents the value to be rounded.
- Meaning: It rounds the number to the nearest even integer.
- Example: odd(4.45) = 5 (5 is the nearest odd number to 4).
7. Odd Function
- Syntax: Odd(number).
Where number is the value to be rounded.
- Meaning: It rounds up to the nearest odd integer.
- Example: odd(4.45) = 5 (5 is the nearest odd number to 4).
8. Rounddown Function
- Syntax: rounddown(number, digits).
Function that rounds down by 1 unit.
- Example: round(4.45,1)=4.4
9. Sum Function - Summation Function
- Syntax: Sum(number1, number2, ….).
+ Where number represents the values to be summed.
- Example:
10. Sumif Function - Conditional Summation Function
- Syntax: Sumif(range, criteria, num_range).
Within which:
+ Range: denotes the range determining the condition.
+ Criteria: the condition.
+ Num_range: values to be summed.
- For instance:
12. Function Average
- Syntax: average(number1, number2, …).
Where: number1, number2 are the numbers to be averaged.
- For example:
12. Sumproduct Function
- Syntax: sumproduct(array1, array2, …).
Where: array1, array2 are arrays where:
+ Each array is multiplied together and then summed up.
13. Max Function
- Syntax: Max(number1, number2,…).
Where: number1, number2,…number n are the sequence of numbers to determine the maximum value.
- Meaning: Function to find the smallest value in a sequence of numbers.
- Example:
14. Min Function
- Syntax: Min(number1, number2,….number n).
- Meaning: Function retrieves the smallest value in a sequence. Similar to the Max function.
15. Small Function
- Syntax: Small (array, k).
Where:
+ Array represents an array of values.
+ K stands for the ordinal number of the element with the k-th smallest value.
- Meaning: The function returns the element with the k-th smallest value in the sequence.
- Example:
16. Function Count
- Syntax: Count (Value1, Value2, …).
Where:
+ Value1, Value2 are values in the sequence.
+ Value1, Value 2 belong to numeric type.
- Meaning: The function counts numeric data.
- Example:
17. Function Counta - Count all cells containing data
- Syntax: Counta(Value1, value2,….).
18. Function Countif
- Syntax: Countif (range, criteria).
Where:
+ Range: Data sequence to operate on.
+ Criteria: Condition for counting.
- Meaning: Used to count cells containing data based on a condition.
- Example:
