Common math functions in Excel
Summary of common calculation functions in Excel for accountants.
1. ABS function
- Syntax: ABS (number).
+ Where number is a numerical value it can be a parameter, reference or valuable expression.
- Functional meaning: is the function that returns the absolute value of a number.
- Example: abs (-5) = 5; abs (5) = 5
2. Power function
- Syntax: power (number, power)
Inside:
+ Number is the real number.
+ Power is an exponential function (or is understood as a factor that is multiplied).
- Meaning of the function: A function that performs exponentiation.
- For example:
Common math functions in Excel Picture 1
3. Product function
- Syntax: Product (number1, number2, .).
Inside:
+ Number 1 is the 1 factor.
+ Number 2 is the second factor . .
+ Contains up to 255 number arguments.
- Meaning: As a function of product of a sequence of numbers.
- For example:
Common math functions in Excel Picture 2
4. Function Mod
- Syntax: Mod (number, divisor).
Inside:
+ Number: is the divisor.
+ Divisor: is the number to be divided.
+ If the divisor = 0 return value is False.
- The meaning of the function returns the remainder of the division (the signed balance of the dividend).
- For example:
Common math functions in Excel Picture 3
5. Roundup function
- Meaning: is a rounding function for decimal numbers.
- Syntax: roundup (number, Num_digits).
Inside:
+ Number is the number you want to round.
+ Num_digist: is the range to be rounded up to a few digits. Based on num_digist will determine the rounding rule.
- For example:
+ round (2.45, 0) = 5
+ round (2.45, 1) = 2.5
+ round (2.45, -1) = 10
6. The Even function
- Syntax: Even (number).
+ Where number: is the number to be rounded.
- Meaning: A rounding function but rounded up to the nearest even integer.
- Example: even (4.45) = 6 (6 is the nearest even number of 4).
7. The odd function
- Syntax: Odd (number).
Where number is the number to be rounded.
- Meaning: A function to round but round up to the nearest odd integer.
- Example: odd (4.45) = 5 (5 is the nearest odd of 4).
8. Rounddown function
- Syntax: rounddown (number, digits).
A rounding function, but rounded down to 1 unit.
- Example: round (4.45,1) = 4.4
9. Sum function - Function sum
- Syntax: Sum (number1, number2, .).
+ Where number is the value to sum.
- For example:
Common math functions in Excel Picture 4
10. Sumif function - Function for calculating conditional sum
- Syntax: Sumif (range, criteria, num_range).
Inside:
+ Range: range to determine conditions.
+ Criteria: conditions.
+ Num_range: value to sum.
- For example:
Common math functions in Excel Picture 5
11. The Average function
- Syntax: average (number1, number2, .).
In which: number1, number2 are average numbers.
- For example:
Common math functions in Excel Picture 6
12. Sumproduct
- Syntax: sumproduct (array1, array2, .).
Where: array1, array2 are arrays where:
+ The product of each array is included and then summed.
13. Ham Max
- Syntax: Max (number1, number2, .).
Where: number1, number2, . number n is the sequence to determine the maximum value.
- Meaning: The function finds the maximum value of a sequence of numbers.
- For example:
Common math functions in Excel Picture 7
14. Ham Min
- Structure: Min (number1, number2, . .number n).
- Meaning: The function takes the smallest value in the sequence. Similar to the Max function.
15. Small function
- Syntax: Small (array, k).
Inside:
+ Array is an array of values.
+ K is the ordinal number of the element with the smallest value k.
- Meaning: The function returns the smallest k value in the sequence.
- For example:
Common math functions in Excel Picture 8
16. Ham Count
- Syntax: Count (Value1, value2, . .).
Inside:
+ Value1, Value2 are values in the range.
+ Value1, Value 2 are numeric.
- Meaning: Data counting function is numeric.
- For example:
Common math functions in Excel Picture 9
17. Counta function - Counts all cells that contain data
- Syntax: Counta (Value1, value2, .).
18. The Countif function
- Syntax: Countif (range, criteria).
Inside:
+ Range: Data range of operation.
+ Criteria: Conditions for counting.
- Meaning: Using to count cells containing data under 1 condition.
- For example:
Common math functions in Excel Picture 10
You should read it
- Summary of trigonometric functions in Excel
- Common Excel functions you need to know about accounting
- How to use math functions in C#
- Common calculation functions in Excel
- math.h in C
- Common mistakes in using Excel functions
- Common mistakes in Excel and how to fix them
- How to fix the SUM function doesn't add up in Excel
- 10 EXCEL functions that ACCOUNTERS often use
- The MIN and MAX functions (the smallest and largest value functions) in Excel
- Complete financial functions in Excel you should know
- Basic common calculation functions to know in Excel