Office-Excel 120个常用函数集

Office-Excel 120个常用函数集
Office-Excel 120个常用函数集

A类1abs26day

2average27days360

3averagea28dsum

4and29dollar

5address E类30evaluate

6areas31exact

7asc32emonth

C类8ceiling33even

9count34exp

10counta F类35find

11counif36floor

12countblank37false

13cell38frequency

14code39fixed

15char G类40get.cell

16choose41gcd

17clean H类42hlookup

18column43hour

19columns44hyperlink

20combin I 类45if

21concatenaet46int

D类22date47index

23datedif48indirect

24datestring49iserror

25datevalue50isblank

51iseven76offset101

52isnumber P类77power T类102

53isodd78proper103

54istext79product104 L类55large Q类80quotient105 56len R类81right106

57lenb82rightb107

58left83rept108

59leftb84row109

60lower85rows110

61lcm86rank111

62lookup87rand U类112 M类63max88randup V类113 64maxa89randdown114

65min90randbetween W类115

66mina91rmb116

67mod92replace117

68mid S类93sum118

69minute94search119

70mode95sumif其它120 N类71not96second 二○一三年四月四日

星期四

72n 97sqrt 73now

98subtatol 74

networkdays 99sumproduct O类

75or 100

small

type

trim

time

today timevalue trunc transpose t

text

upper value vlookup weekday workday weeknum widechar year

&

相关文档
最新文档