¼Æ¦r+³æ¦ì ¦³¿ìªk¨ú¥§¡È¶Ü?
- ©«¤l
- 161
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-9-16
- ³Ì«áµn¿ý
- 2017-2-19
|
¦^´_ 10# sptakung1
¬Æ»òª¬ªp¤U¨Ï¥Î°}¦C¤½¦¡, ¬Ý¤½¦¡ªº»Ýn¡C
¨Ò¤l :
AVERAGE(¼ÆÈ1, [¼ÆÈ2],...)
¨âÓ¤½¦¡
{=AVERAGE(--LEFT(A1:A10,LEN(A1:A10)-2))}
{=AVERAGE(--SUBSTITUTE(A1:A10,"k£[",))}
ªð¦^
{=AVERAGE(--(¤å¦r¼ÆÈ1,¤å¦r¼ÆÈ2,¡K.))}
»Ýn"--" Âà´«¦¨¯u¥¿¼ÆÈ
{=AVERAGE(¯u¥¿¼ÆÈ1,¯u¥¿¼ÆÈ2,¡K.)}
Âà´«¦¨¯u¥¿¼ÆȦZ, »Ýn°}¦C¤½¦¡ªð¦^结ªG¡C |
|
|
|
|
|
|
- ©«¤l
- 32
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 68
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- «n§ë¿¤
- µù¥U®É¶¡
- 2010-9-28
- ³Ì«áµn¿ý
- 2019-10-4
|
¦^´_ 11# JBY
JBY¤j¤j±z¦n¡Gº¥ý·PÁ±z¼ö¤ßªº«ü¾É¡A§Ú¤§©Ò¥H¼ö·RµÛ³oÓ®a±Ú¥Dnªºì¦]´N¦b³o¸Ì¡A³oÃä¨S¦³¯ÉÂZªºÂźñª§°«¡A¦³ªº¬O¥xÆW¤Hªºªº¤H¨ý¤Î¼ö±¡¡A³o¸Ì³B³B¥i¨£¡Cè誦¹LEXCEL HELPªº»¡©ú¡A¥DÃD¡G°}¦C¤½¦¡ªº³W«h¤Î½d¨Ò¡A¬Ý¹L»¡©ú¤Î½d¨Ò«á¦]¥»¤H¸ê½è¬Æ®t¡A¦üÀ´«DÀ´ªº·Pı§Ú·Q¬O¦]¬°¨ÒÃD°µªº¤£°÷¤~·|¦p¦¹§a¡C
³Ì«áP¤W§Ú³Ì°J¤ßªº¯¬ºÖ¡A´Á±æ±z®É®É¦N²»¨Æ¨Æ¦p·N¡C |
|
|
|
|
|
|
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
¦^´_ 10# sptakung1
¨Ï¥Î°}¦C¤½¦¡ªº®É¾÷¡A´N¬Ý§A¬On²£¥Í³æ¤@ªºÈ,ÁÙ¬On²£¥Í¤@²ÕªºÈ
=AVERAGE(--LEFT(A1:A10,LEN(A1:A10)-2)) ·|²£¥Í¤@ÓA1:A10¥h°£¥kÃä¨âÓ¦r¤¸ªº¤@²Õ¼ÆÈ¡A©Ò¥Hn¥Î¨ì°}¦C¤½¦¡
=LEFT(A1,LEN(A1)-2) ¬O¨ú³æ¤@È¡A¨º´N´¶³q¤½¦¡§Y¥i¡C |
|
|
|
|
|
|
- ©«¤l
- 32
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 68
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- «n§ë¿¤
- µù¥U®É¶¡
- 2010-9-28
- ³Ì«áµn¿ý
- 2019-10-4
|
¦^´_ 13# ANGELA
ANGELAª©¥D«D±`·PÁ±z¡A±zªº³o¥y¡¨·|²£¥Í¤@ÓA1:A10¥h°£¥kÃä¨âÓ¦r¤¸ªº¤@²Õ¼ÆÈ¡A©Ò¥Hn¥Î¨ì°}¦C¤½¦¡¡¨¨Ï§ÚT¶ë¹y¶}¡Aì¨Ó¨ì³Ì«áAVERAGE¹Bºâªº¬O¤@Ó{1;2;3;4;5;6;7;8;9;10}¦p¦¹ªº¼Æ²Õ¡A¦Ó§Ú¤@ª½»~·|AVERAGE³Ì«á¹Bºâªº¬O¥h°£K£[«áªº(A1:A10)ªº°Ñ·Ó½d³ò¡A©Ò¥HÃø©Ç¶·¥Î°}¦C¤½¦¡¤F¡C¦b¦¹¦A¤@¦¸ªí¹F§Ú³Ì¸Û¼°ªºÁ·N¡AÁÂÁ±z¡I |
|
|
|
|
|
|
- ©«¤l
- 17
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 33
- ÂI¦W
- 0
- §@·~¨t²Î
- XP SP3
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-4-30
- ³Ì«áµn¿ý
- 2012-12-21
|
¦^´_ 2# ANGELA
«z!! ¦h´CÅé±Ð¾Ç! |
|
|
|
|
|
|