The most commonly used Excel function formula in work

computer stuff. 2016-05-18 22:23:02 Microsoft Formula work reading (22574) Comments (1) Statement: This article by the Sohu public platform to write the author, in addition to the official Sohu account, the view is only representative of the author himself, does not represent the position of Sohu. Report

Word, Excel, PPT is our daily life, the longest use of three tools. Each tool in the use of the process has some knowledge and skills, today, " computer things " small to everyone brought to you is the Excel function formula summary, especially the clerk or learning accounting of small partners quickly collection, a rise knowledge bar!

　　First, the digital processing

　　1, take absolute value

=abs (digital)

　　2, take the whole

=int (digital)

　　3. Rounding

=round (number, number of decimal digits)

　　Second, the judgment formula

　　1, the error value generated by the formula is displayed as null

Formula: C2

=iferror (A2/B2, "")

Description: If the error value is displayed as empty, otherwise normal display.

　　2, if multi-conditional judgment return value

Formula: C2

=if (and (a2<500,b2= "not Expired"), "replenishment", "" ")

Description: Two conditions are set up with and, either set up with or function.

　　Three, the statistical formula

　　1, Statistics two table duplicate content

Formula: B2

=countif (sheet15! A:A,A2)

Description: If the return value is greater than 0, the description exists in the other table, and 0 does not exist.

　　2. Total number of non-repeating statistics

Formula: C2

=sumproduct (1/countif (A2:A8,A2:A8))

Description: Use COUNTIF to count the number of occurrences of each person, with 1 in addition to the number of occurrences into the denominator, and then add.

The most commonly used Excel function formula in work