*Download now 70+ basic and advanced excel exercises*

You are a person who is often exposed to the work of calculating and using excel calculation functions. Surely with the launch of Microsoft Office 2013, you are also familiar with trigonometric and mathematical functions in Excel and many other mathematical functions

### Common functions in Excel

In today‘s article, Software will summarize the most common calculation functions in **basic Excel** to help you more convenient in your calculation work, the main **calculation functions** are the

Common functions are often used throughout the process of learning and working with excel, common functions include basic functions as well as advanced functions, if you have mastered some basic functions in excel, then with the

## Summarize common calculation functions in Excel

**The content of the article:****1. Normal summing function, conditional summing function 2. Excel Average Calculation Function 3. Function to find largest and smallest values in Excel 4. Data counting function in Excel 5. Excel Logic Function 6. Math functions in Excel **

**In Excel spreadsheets** there are quite a few calculation functions, from basic calculation functions to advanced calculation functions, all of which we will update in this article. All the calculation functions of Excel below are used by Software on Office Excel 2013 version, you can completely apply to other versions of Office Excel such as Excel 2016, **2010, 2007 or Excel 2003**

*1. Ordinary sum violet function, conditional sum function*

The first excel calculation function that Software will share with you is the normal sum function, including SUM function, SUMIF function.

*SUM function*

Add all numbers in a selected data area.**Syntax: SUM(Number1, Number2…)**

Parameters: Number1, Number2… are the numbers to be summed.

*SUMIF function*

Calculates the sum of cells specified by the input criteria.** Syntax: SUMIF(Range, Criteria, Sum_range)**

Parameters:

– Range: The range that you want to define.

– Criteria: the criteria by which you want to sum. This standard can be numbers, expressions or strings.

– Sum_range: Are cells that really need summing.

*2. Excel Average Calculation Function*

The popular and widely used excel calculation function is the average value calculation function. The AVERAGE, SUMPRODUCT functions will be shared by Software below.

*AVERAGE function*

Returns the average of arguments.**Syntax: AVERAGE(number1, number2…)**

Parameters: number1, number2 … are the numbers that need to calculate the average value.

**For example**:

Formula **E6=AVERAGE(C6:D6)**

*SUMPRODUCT function*

Take the product of the sequences inserted, then calculate the sum of those products**Syntax: SUMPRODUCT(Array1, Array2, Array3…)**

Parameters: Array1, Array2, Array3… are the ranges of cells that you want to multiply and then sum the products.

- Heed
- The arguments in the sequences must be in the same direction. Otherwise, the function will return an error value #VALUE

**3. Function to find largest and smallest values in Excel**

**3. Function to find largest and smallest values in Excel**

The calculation function in Excel also includes the function of finding large and small values in Excel. Each function will have a different syntax and reference.

*MAX function*

Returns the largest number in the entered range.**Syntax: MAX-(Number1, Number2…)**

Parameters: Number1, Number2… is the range in which you want to find the maximum value

*LAGRE function*

Find the k-th largest number in an entered sequence.**Syntax: LARGE(Array, k)**

Parameters: Array: Is an array or area of data.

k: Is the rank of the number you want to find since the largest number in the sequence.

*MIN function*

Returns the smallest number in the sequence entered.**Syntax: MIN(Number1,Number2…)**

Parameters: Number1, Number2… is the range in which you want to find the smallest value.

*SMALL function*

Find the k-th small number in an entered sequence.**Syntax: SMALL(Array, k)**

Parameters: Array: Is an array or region of data.

k: Is the rank of the number you want to find since the smallest number in the sequence

*4. Data counting function in Excel*

*COUNT function*

This function is used to count cells that contain numeric type data in a range**Syntax: COUNT(Value1, Value2, …)**

With parameters: Value1, Value2… is an array or range of data.

*COUNTA function*

Count all cells that contain data.**Syntax: COUNTA(Value1, Value2, …)**

Parameters: Value1, Value2… is an array or range of data.

*COUNTIF function*

This function counts cells containing numeric values under a given condition.**Syntax: COUNTIF(Range, Criteria)**

Parameters:

– Range: The range of data that you want to count.

– Criteria: Is the standard for cells to be counted.

Get

*5. Excel Logic Function*

**AND function**

**With syntax: AND(Logical1, Logical2, ….)**

– Arguments: Logical1, Logical2… are conditional expressions.

– The function returns the value TRUE (1) if all of its arguments are true, returns the value FALSE (0) if one or more of its arguments are false.

- – The arguments must be logical values or arrays or references containing logical values.

– If the reference argument is text or Null values, those values are ignored.

– If the reference area does not contain a logical value, then the function returns an error #VALUE!

**Example 1**: Use the AND function to know if the following formulas are true or false.

Cell formula A6 is:**=AND(A6=”Nguyen Van Dat”, B6=”Nam”)**, which returns TRUE

*OR function*

**With syntax: OR (Logical1, Logical2…)**

– In which arguments: Logical1, Logical2… are conditional expressions.

– The OR function will return the value TRUE (1) if any of its arguments are true and FALSE (0) if its arguments are false.

*NOT function*

**Syntax: NOT(Logical)**

– Where the Logical argument is a value or a logical expression

– The NOT function has the function of reversing the value of the argument. The function is used when you want to negate the value of an argument in this operation

*6. Math functions in Excel*

The next Excel calculation function is the math function. You guys pay attention to know the syntax, use the correct function.

*ABS function*

A function that returns the absolute value of a number. The absolute value of a number is that it has no sign**Syntax: ABS(number)**

– The number argument is a numeric value, a reference, or an expression.

**Example:** The cell formula D9 is : =ABS(C9) and we have the result :

*POWER function*

The function returns the result of a number lifted by an extra implication**With syntax: POWER(number, power)**

– Number parameter: Is any real number

– Power: An exponential function by which you want to raise the base number to powers

*PRODUCT function*

You can use the PRODUCT function instead of the multiplication operator * to calculate the product of an array.**Syntax: PRODUCT(number1, number2…)**

– Where parameter: Number1 is the first number you want to multiply

Number2 is the additional numbers or ranges that you want to multiply, up to a maximum of 255 arguments

- Heed
- If the array or reference argument is multiplied only the numbers in the array or reference

**Example: ** Calculate the product of each column in the following data table:

*MOD function*

A function that returns the remainder after dividing a number by a divisor, resulting in the same sign as the divisor

**Syntax: MOD(number, divisor)**

– The argument :Number is a divided number

The divisor is a divisor

- Heed
- If the divisor is 0, the MOD function will return the error value #DIV/0!

The MOD function can be expressed by the terms of the INT function: MOD(n, d) = n – d*INT(n/d)

*ROUNDUP function*

This function rounds a number to 0

**Syntax: ROUDUP(Number, Num_digits)**

– Parameters: Number: Is an actual number that you want to round up.

Number_digits: is the number of digits that you want to round the number to

- Heed
- If Num_digits > 0 Will round the specified decimal part

If Num_digits = 0 Will round up the nearest natural number

If Num_digits < 0="" sẽ="" làm="" tròn="" về="" phía="" bên="" trái="" của="" dấu="" thập="">

*EVEN function*

A function that returns a number rounded up to the nearest even integer

**With syntax: EVEN(Number)**

-where the parameter number is the value to be rounded

- Heed
- If Number is not a numeric type, the function returns an error #VALUE!

*ODD function*

This function rounds up to the nearest odd integer

**Syntax: ODD(Number)**

Parameter: Number is the number that you want to round

*ROUNDDOWN function*

This function helps you round down a number

**Syntax: ROUNDDOWN(number, num_digits)**

-Parameters:

Number is the real number that you want to round

Num_digits is the number of digits you want to round to

https://thuthuat.taimienphi.vn/ham-tinh-toan-thong-dung-trong-excel-2013-1515n.aspx

In the above article, Software has compiled basic calculation functions in Excel 2016, 2013, 2010, 2007, 2003, . Hope to help readers at work. If you are interested, you can refer to the financial functions in Excel. Thank you for following the article.