A complete set of wps function formulas and their usage

Wps function formula and usage are as follows:

1, the formula for finding duplicate contents: =IF(COUNTIF(A:A, A2)> 1, "duplicate", "duplicate")

2. Formula for calculating contract expiration: = edate (A4,3)

3. Conditional summation: Calculate the total sales of a unit: =SUMIF(B:B, "sell a unit", C:C).

4. Multi-conditional summation: Calculate the sales amount of one unit above 1000: =SUMIFS(C:C, B:B, "selling one unit", C:C, "> 1000").

5. Minimum value of specified condition: {=MIN(IF(B2:B 10= "sell one", C2:C 10))}

6. Maximum value of specified condition: {=MAX(IF(B2:B 10= "sell one", C2:C 10))}

7. Average value of specified conditions: =AVERAGEIF(B2:B 10, "sell one", C2:C 10).

8. Multi-conditional counting: =COUNTIFS(B2:B 10, "sell one", C2:C 10, "& gt950").