Commonly used formulas, now is the Internet age, it is very important to know how to use computers, computers can bring us a lot of convenience, and some office software can also bring us a lot of convenience. Here are some commonly used formulas.

Daquan of Common Formulas1i. Digital Processing

1, absolute value

=ABS (number)

2, rounding

=INT (number)

3, rounding

=ROUND (number, decimal place)

Second, the judgment formula

1. Displays the error value generated by the formula as empty.

Formula: C2

=IFERROR(A2/B2，"")

Description: If it is an error value, it is empty, otherwise it will be displayed normally.

2. If multiple conditions determine the return value.

Formula: C2

= IF(AND(A2 & lt； 500, b2= "not expired"), "replenishment", "25 =" $ E2) * $ c $2: $ c $25) < /p " p = " " style = " margin-top:0px； Margin-bottom: 0px padding: 0px "img =" "alt =" image.png "src ="/image/202206/08/1654 67022662a 043927a 664563787.png "title ="1654 67022662a. /p " ol = " " class = " content-list-text " div = " " max = " " a = " " log = " type:20 15083 1，pos:enter _ step " & gt； 90")

5. Select E2:E5 as the number of people in each score, enter the following formula, and press Shift+CTRL+ENTER = frequency (B2: B7, {70; 80; 90})

6. According to the statistical average of conditions, the average score of men's assessment is counted. =AVERAGEIF(B2:B7, "male", C2:C7)

7. Multi-conditional statistics average the average score of the assessment with gender as "male" and department as "sales". =AVERAGEIFS(D2:D7, C2:C7, "male", B2:B7, "sales")

8. Calculate the number of non-duplicate items = SUMPRODUCT (1/COUNTIF (A2:A9, A2: A9))

9. Extract the content that is not repeated, enter the following array formula in cell C2, and press Ctrl+ Shift+Enter to copy it. =INDEX(A:A， 1+MATCH(，COUNTIF(C$ 1:C 1，A$2:A$ 10)，)& amp""

10

10, find duplicate contents =IF(COUNTIF(A:A, A2)> 1, "duplicate", "duplicate")