ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¼Æ¦r+³æ¦ì ¦³¿ìªk¨ú¥­§¡­È¶Ü?

¼Æ¦r+³æ¦ì ¦³¿ìªk¨ú¥­§¡­È¶Ü?

§Ú©Ò¥H¥Îªº³nÅé·|±N¼Æ­È¿é¥X¦¨EXCEL

¦ý¬O¥L¿é¥X«áªºµ²ªG³£·|¦³³æ¦ì
¦p
         A       B
1  1k£[        5k£[
2 2k£[        7k£[
3 3k£[        9k£[

¦pªG§Ú¥´
A4=(A1+A2+A3)/3
³£·|¥X¿ù
½Ð°Ý¦b¤£¯}Ãa³æ¦ìªº±¡ªp¤U
¦³¸Ñ¶Ü?

¥»©«³Ì«á¥Ñ ANGELA ©ó 2012-9-13 21:47 ½s¿è

aaa.gif
¦pªG¥i¥H¥h±¼³æ¦ì,¨º¥Î´À¥N§Y¥i.
©Î
=AVERAGE(--LEFT(A1:A10,LEN(A1:A10)-2))

TOP

¦^´_ 1# v60i


   

TOP

ÁÂÁ¨â¦ì¤j¤jªº¥æ¾Ç

TOP

¦^´_ 2# ANGELA
¦^´_ 3# white945
½Ð°Ý¨â¦ì¤j¤j

¤½¦¡ªº -- ¬O¥Nªí¤°»ò·N«ä©O?

TOP

¥»©«³Ì«á¥Ñ JBY ©ó 2012-9-16 21:24 ½s¿è

©Î

{=AVERAGE(--SUBSTITUTE(A1:A10,"k£[",))}

TOP

¦^´_ 5# v60i


   --±N¥Nªí¬Y¼Æ­Èªº¤å¦r¦r¦êÂà´«¦¨¼Æ¦r¸ê®Æ,¥¿³Wªº¥Îªk¬OVALUE(), ¨ä¥¦ÁÙ¦³*1©Î+0³£¥i¥H

TOP

¦^´_ 7# ANGELA
·Q½Ð±Ð¦U¦ì¤j¤j¡A­Y«öANGELAª©¥Dªº¤½¦¡°µ®É·|²£¥Í#VALUE!¡A¤@©w­n¦pJBY¤j¤jªº¤½¦¡¿é¤J¦¨°}¦C¤½¦¡¦p¥k{=AVERAGE(--SUBSTITUTE(A1:A10,"k£[",))}¤~¯à±o¨ìµ²ªG¡A³o¬O¬°¤°»ò©O¡H§Æ±æ¦U¦ì«e½ú¸Ñ´b¡CÁÂÁ¡I

TOP

©êºp¡A¨Sª`©ú¬O°}¦C¤½¦¡¡C
¨ä¹ê³o¨â­Ó¤½¦¡«ä¸ô¤£¦P¡Cµ²ªG¬O¤@¼Ëªº¡C
=AVERAGE(--LEFT(A1:A10,LEN(A1:A10)-2))¬O¨úA1¨ìA10¤£§t³æ¦ìªº­È
=AVERAGE(--SUBSTITUTE(A1:A10,"k£[",))     ¬O´À´«³æ¦ìªº¦r¤¸¬°ªÅ¦r¦ê¡C

TOP

¦^´_ 9# ANGELA
ANGELAª©¥D½Ð±z¤£»¡©êºp¡A§Ú¨Ã¨S¦³¥ô¦ó§äâíªº·N«ä¡C¦pªG§Úµ¹±z¦³¦p¦¹ªº·Pı¬O¦X¸Ó§Úµ¹±z»¡©êºp¤~¹ï¡C¨ä¹ê¤µ¤Ñ¹ï³oijÃD§Ú·P¨ì¤£¸Ñªº¬O¤£ºÞ¬O²Ä1­Ó©Î¬O²Ä2­Ó¤½¦¡
1.        =AVERAGE(--LEFT(A1:A10,LEN(A1:A10)-2))
2.        =AVERAGE(--SUBSTITUTE(A1:A10,"k£[",))
±qÅÞ¿è¤W¨Ó§PÂ_À³¸Ó´N¥i¥H¹F¦¨ÃD¥Øªº­n¨D¡A¦ý¦b¹ê»Ú°õ¦æ¤§«á«oµo¥Í»P©Ò·Qªºµ²ªG¤£¦P¡A¥i¯à¬O¦]¬°¦Û¤v¹ï°}¦C¤½¦¡ªº¨Ï¥Îºâ¬O¤ñ¸ûÆZ­¯¥ÍªºÃö«Y¡A¦pªG¤µ¤Ñ¬O§Ú¹J¤W¦pÃDªºª¬ªp«ç»ò¼Ë¤]¤£·|·Q¨ì¡A¥u­n±N¤½¦¡¿é¤J¦¨°}¦C¤½¦¡§Y¥i¹F°}¡C¤]´N¬O»¡§Ú¸Ó¦b¬Æ»òª¬ªp¤U´N­n¨Ï¥Î°}¦C¤½¦¡¡A´«¥y¸Ü»¡¨Ï¥Î°}¦C¤½¦¡ªº¥¿½T®É¾÷¬O¬Æ»ò±¡ªp¡A­Y¬O¤è«K½Ð§iª¾¡C³Ì«á¯¬ºÖ±z¦N²»¦p·N¡AÁÂÁ¡C

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD