- ©«¤l
- 38
- ¥DÃD
- 22
- ºëµØ
- 0
- ¿n¤À
- 59
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ·s¦Ë¥«
- µù¥U®É¶¡
- 2013-12-12
- ³Ì«áµn¿ý
- 2014-6-12
|
Excel ±`¥Î¨ç¼Æ
²Ä¤@³¡¥÷ ¼Æ¾Ç¨ç¼Æ
Average ¨ç¼Æ
½d¨Ò http://www.tkgsh.tn.edu.tw/wpy/excel/excel_function_examples/3-6-01.xls
¥Îªk¡GpºâÀx¦s®æ½d³òªº¥§¡È
»yªk¡GAVERAGE(Àx¦s®æ1 : Àx¦s®æ2)
Abs ¨ç¼Æ
½d¨Ò http://www.tkgsh.tn.edu.tw/wpy/excel/excel_function_examples/3-6-02.xls
¥Îªk¡G±N¼ÆÈÂà´«¦¨µ´¹ïÈ (¤]´N¬O¨S¦³t¸¹ªº¼ÆÈ)
»yªk¡GABS(Àx¦s®æ) ©Î ABS(¼ÆÈ)
Round ¨ç¼Æ
½d¨Ò http://www.tkgsh.tn.edu.tw/wpy/excel/excel_function_examples/3-6-03.xls
¥Îªk¡G±N¼ÆÈ¥|±Ë¤¤J¨ì²ÄN¦ì¼Æ
»yªk¡GROUND(Àx¦s®æ1 , N)
Int ¨ç¼Æ
½d¨Ò http://www.tkgsh.tn.edu.tw/wpy/excel/excel_function_examples/3-6-04.xls
¥Îªk¡G±N¼ÆȪº¤p¼Æ¦ì¼Æ¡AµL±ø¥ó±Ë¥h¡A¯d¤U¾ã¼Æ³¡¥÷
»yªk¡GINT(Àx¦s®æ)
Mod ¨ç¼Æ
½d¨Ò http://www.tkgsh.tn.edu.tw/wpy/excel/excel_function_examples/3-6-05.xls
¥Îªk¡G¨D±o¨â¼ÆȬ۰£«áªº¾l¼Æ¡A¦pªG°£¼Æ¬°0¡A±N¶Ç¦^¿ù»~°T®§
»yªk¡GMOD(³Q°£¼Æ¡A°£¼Æ)
Max ¨ç¼Æ
½d¨Ò http://www.tkgsh.tn.edu.tw/wpy/excel/excel_function_examples/3-6-06.xls
¥Îªk¡G¨D±o¬YÀx¦s®æ½d³òªº³Ì¤jÈ
»yªk¡GMAX(Àx¦s®æ1¡GÀx¦s®æ2)
Min ¨ç¼Æ
½d¨Ò http://www.tkgsh.tn.edu.tw/wpy/excel/excel_function_examples/3-6-06.xls
¥Îªk¡G¨D±o¬YÀx¦s®æ½d³òªº³Ì¤pÈ
»yªk¡GMAX(Àx¦s®æ1¡GÀx¦s®æ2)
Count ¨ç¼Æ
½d¨Ò http://www.tkgsh.tn.edu.tw/wpy/excel/excel_function_examples/3-6-07.xls
¥Îªk¡G¨D±o¬YÀx¦s®æ½d³ò¤¤¡A¥]§t¼Æ¦rªºÀx¦s®æ¼Æ¥Ø
»yªk¡GCOUNT(Àx¦s®æ1¡GÀx¦s®æ2)
Large ¨ç¼Æ
½d¨Ò http://www.tkgsh.tn.edu.tw/wpy/excel/excel_function_examples/3-6-08.xls
¥Îªk¡G¨D±o¬YÀx¦s®æ½d³ò²ÄN¤jªº¼ÆÈ
»yªk¡GLARGE(Àx¦s®æ1¡GÀx¦s®æ2¡AN)
Small ¨ç¼Æ
½d¨Ò http://www.tkgsh.tn.edu.tw/wpy/excel/excel_function_examples/3-6-09.xls
¥Îªk¡G¨D±o¬YÀx¦s®æ½d³ò²ÄN¤pªº¼ÆÈ
»yªk¡GSMALL(Àx¦s®æ1¡GÀx¦s®æ2¡AN) |
|