关于对HR常用EXCEL函数公式的注解1

函数说明语法

示例ABS 返回绝对值

38

COUNT 返回参数的个数

20

COUNTA

22

COUNTBLANK 4

COUNTIF

2

EXP

求e 的 n 次幂

403.4288

FACT

求数的阶乘

24

LN

求一个数的自然对数

2.302585

LOG 求一个数的对数

2

LOG10 求以 10 为底的对数

2

PRODUCT 求乘积值

30

SIGN

求数字的符号1A > 00A = 0

-1

A < 0

返回参数组中非空

值的数目

计算指定单元格区

域中空白单元格的数目计算给定区域内满足特定条件的单元格的数目。

302585

2.n e

e ==10

L N L oge oge ==!

!N 4==100

L N L 10OG 10OG ==9

L N L 3OG OGM ===

′′′=′′′=5321N C B A L =

=)"40I (SIGN "=

=)"42I (SIGN "=

=)"44I (SIGN "()=

="2"I ABS

()==?

±￡o16L 4K COUNT

"()==?

±￡o16L 4K COUNTA "=

=)"16L :4K (COUNTBLANK "=

=)"5L ,16L :5L (CONUNTIF "=

=)"28G (EXP "=

=)"25I (FACT "=

=)"28I (LN "=

=)"31J ,31I (LOG "=

=)"34I (10L OG "=

=)"37L ,37K ,37J ,37I (PRODUCT "

4

SUM 返回某一单元格区域中所有数字之和

SUMIF 根据指定条件对若干单元格求和

SUMPRODUCT 并返回乘积之和

SUMSQ 求所有参数的平方和

SUMX2MY2 求两数组中对应数值的平方差之和

SUMX2PY2 求两数组中对应数值的平方和之和

SUMXMY2 求两数组中对应数值之差的平方和=

++++==?N B B A A X L L 121=

+++======?1111i i i i N B A X L (

)()()?=

+′+′=′=

L 2211B A B A B A =

+++==?222

21

2

N

A A A X L ()=

-=

?N

B A

1

2

2

()=

+=

?N

B A

1

22

()?

-=

N

1

2

B

A

=

=)"47I (SQRT "=

=)"67M :50L (SUM "==)"67M :50L ,50K ,67K :50K (SUM "=

=)"67M :50M ,67L :50L (SUMPRODUCT "=

=)"67M :50L (SUMSQ "=

=)"67M :50M ,67L :50L (2PY 2SUMX "=

=)"67M :50M ,67L :50L (2SUMXMY "=

=)"67M :50M ,67L :50L (2MY 2SUMX "

-38

6

4

10

93

100

1235 10

-10

16

组别A B 3938.22190.53142.12

288.43163.17

347.3763.16 =)"67M:0

648.462175.8166.33

1100.01144.75

246.32126.33 221661.5373.69138.96

3105.27126.33

186.32121.06 166701.6360.0173.69

190.53142.12

288.43163.17 -154701247.3763.16

1175.8166.33

3100.01144.75 488104.1246.32126.33

273.69138.96

1105.27126.33 44781.14