Basic Common Calculation Functions to Know in Excel

This article provides a clear overview of Basic Common Calculation Functions to Know in Excel, with the main facts, useful context, and practical details organized for easy reading.

A. THE USE OR USE

1. Left Function

- Meaning: Returns the number of characters to start from the first character on the left.

- Example: LEFT ("TipsMake. vn", 8) = "thuthuat".

2. VLOOKUP Function

- Syntax: VLOOKUP (lookup value, lookup table, return value column, lookup type) .

- For example:

Detector value: bar code column.

Table: TRA TABLE 1.

Return value: column name of company.

Detection type: Leave the value = 0 (accurate detection).

3. LEN Function

- Syntax: LEN (text) .

- Meaning: Returns the number of characters in a string.

- Example: LEN ("TipsMake. vn") = 18.

4. MID Function

- Syntax: MID (character string, starting position, number of characters to be taken) .

- Meaning: Returns the substring of a character in a given string starting at a certain position.

- Example: MID ("TipsMake. vn", 9, 9) = "phanmem. vn".

5. RIGHT Function

- Syntax: RIGHT (text, number of characters to get) .

- Meaning: Returns the number of characters to start from the first character on the right.

- Example: RIGHT ("TipsMake. vn", 10) = "phanmem. vn".

6. the VALUE Function

- Syntax: VALUE (text) .

- Meaning: Bringing string values as numbers into mathematical values.

- Example: Value ("0025") = 25.

7. HLOOKUP Function

- Syntax: HLOOKUP (lookup value, lookup table, return value row, lookup type) .

B. GENERAL EXAMPLE

The following data sheet is available:

1. Find the Names of the Items Based on TABLE 1

- Use the Vlookup and Left functions to get the name of the item corresponding to the item code in TABLE 1.

Enter the formula: Vlookup (Left (B3, 1), $ A $ 13: $ B $ 15, 2, 0) .

2. Find the Manufacturer Based on the Last 2 Characters of the Product's Code

If the last 2 characters are "TN" -> "Domestic". If other characters are found in TABLE TRA 2.

Enter the following statement: IF (RIGHT (B3, 2) = "TN", "Domestic", HLOOKUP (RIGHT (B3, 2), $ F $ 12: $ J $ 13, 2, 0)) .

3. Calculate the Unit Price Based on the First Letter of the Code and TABLE 1

Results after calculation: