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

[µo°Ý] ¼Æ¦r+³æ¦ì ¦³¿ìªk¨ú¥­§¡­È¶Ü?(²Ä¤G¶°)

[µo°Ý] ¼Æ¦r+³æ¦ì ¦³¿ìªk¨ú¥­§¡­È¶Ü?(²Ä¤G¶°)

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

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


¤£¯à¥Î¨ú¥Nªº¤è¦¡
¦]¬°³æ¦ì®t«Ü¦h
½Ð°Ý­n¥Î¤°»ò¤èªk­pºâ©O?
§Ú¦@¦³1~2¤dµ§³o¼Ë±K±K³Â³Âªº¼Æ¦r+³æ¦ì

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

¦ý¬O¥L¿é¥X«áªºµ²ªG³£·|¦³³æ¦ì
¦p
         A       B
1  1k£[   ...
v60i µoªí©ó 2012-11-19 21:01



§Ñ°O¥´¤]¬O    =(A1+A2+A3+A4)/4

TOP

«Øij..
1.­Y°ÝÃD¬°³s³e©Ê¡A·Ð½Ð¦^©«¦Ü­ì©«¡C
2.±z©Ò¸ß°Ýªº¥­§¡­È.. ¬O¥HÄ欰³æ¦ìÁÙ¬O?
3.±z©Ò»Ý­n¥Î¤½¦¡ ÁÙ¬O µ{¦¡¡H

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

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

¦ý¬O¥L¿é¥X«áªºµ²ªG³£·|¦³³æ¦ì
¦p
         A       B
1  1k£[   ...
v60i µoªí©ó 2012-11-19 21:01


¬O³o·N«ä¶Ü?

zz5151353.rar (1.48 KB)

300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¥»©«³Ì«á¥Ñ mark15jill ©ó 2012-11-20 09:39 ½s¿è

¦^´_ 2# v60i

°Ñ¦Ò¬Ý¬Ý
¤ñ¸û°ò¥»ªº¤èªk....
   
sum.jpg
2012-11-20 09:38



PS ¸Ì­±¦³­Ó 7 ³æ¦æªº ¤£¥Î²z¥L= =  ¨º¬O¥´¿ù..

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-11-20 14:30 ½s¿è

¦^´_ 2# v60i


    ¥Î¤@¤u§@ªí¨Ó­pºâ·|²³æ³\¦h
¨ú¼Æ­È.zip (3.41 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# mark15jill

ÁÂÁ¤j¤jªº«ü±Ð
¦^¤j¤jªº«üÂI1
¬O¨S¦³³s³e©Êªº¡A¥u¬O¹p¦P
¦^¤j¤jªº«üÂI2
¬O¥­§¡­È,·í§Ú­n¦A½s¿è§Ú­n¥­§¡­È®É¨t²Î¥Î¤w¶W¹L3¤ÀÄÁ¬°¥Ñ¤£Åý§Ú½s¿è
¦]¦¹§Ú¦b1¼Ó°¨¤W¤S¦^´_¥­§¡­È
¦^¤j¤jªº«üÂI3
§Ú¤£¬O«ÜÀ´µ{¦¡,©Ò¥H¨S¦³¿ìªk§PÂ_¥Î¤½¦¡¦nÁÙ¬Oµ{¦¡§®
¥u¯à¨DÅý§Ú¹F¨ì¥Ø¼Ðªº´N¥i¥H¤F
·íµM¤£ºÞ¤j¤j´£¨Ñªº¬Oµ{¦¡©Î¬O¤½¦¡³£¨SÃö«Y
§Ú¤]¬O·|·Q¿ìªk²z¸Ñ¦A¥[¥H¹B¥Î

TOP

¦^´_ 4# zz5151353

ÁÂÁ¤j¤jªº¤èªk
«ü¬O¤j¤jªº¤èªk»P¨ú¥N®t¤£¦h

TOP

¦^´_ 6# Hsieh


    ½Ð°Ý¤j¤j ¥u­n¨Ì·Ó¤j¤j¹Ï¤ùµ{¦¡¤W­±¥´ªº´N¦n¤F¶Ü?
¦]¬°ÆZ¦hªº §Ú©È¥´¤@¥´·|ªF¯Ê¤@­Ó¦è¯Ê¤@­Ó
©Ò¥H°Ý²M·¡«á¦A¶i¦æ

TOP

¦^´_ 6# Hsieh


    ÁÂÁ¤j¤jªº¤èªk

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD