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

[µo°Ý] ¤p¾Ç¥Í°ÝÃD 6 (ÁÂÁÂ)

AVERAGE(A1:C1)¬OA1:C1ªº¥­§¡
§A¤£¬O­n¨D¥­§¡´N§âAVERAGE(A1:C1)§ï¬°(A1+B1+C1)/X¤£´N¦n¤F¶Ü¡H
¨ä¥Lªº³£¤£Åܪº¡C

TOP

¦^´_ 11# oobird


   ·PÁ oobird ¶W¤j­@¤ß«ü¾É¡A´N¬O¾Ç¥Í­nªº¡C¶W¯Å·PÁ¡I

   ¾Ç¥Í¹Ï·Q§Æ±æ´M§ä§ó²µuªº¼gªk¡C
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

¦^´_ 10# binargoo


    ®@®@ §Ú»~·|¤F
¤@¶}©lªº·Qªk¬O¥ÎE1 = (A1+B1+C1)/3
¦b±N¤½¦¡«ü¦VE1
­ì¥»³o¤£¬O¤j¤j­nªº

TOP

(A1+B1+C1)/X
x=count(a1:c1)
»Paverage®t¤£¦h,¨S¦³¤°»ò¯S®íªº

¥t:¤£ª¾§Aªº7¬O«ç»ò¨Ó
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 14# gong


   ·PÁ gong ¦Ñ®v«e½ú«ùÄòÃöª`¡A«D±`·P¿E¡C
  
   (A1+B1+C1) / X

   X = ¬°¥ô·N­È¡A³o¬O 7 ªº¥Ñ¨Ó¡A¦A¦¸¦A¦¸·PÁ¡C
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

¥ô·N¼Æ
¥Î¶Ã¼Æ¥i¥H¶Ü?
x=randbetween(1,100)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 16# gong


   ¾Ç¥Íªº¹êÅç¨S¥Î¨ì¡A¦^¥h¦A®M¬Ý¬Ý¡C
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

§Ú¤]¾Ç¨ì¤F
¤£¥Î¥ý§@¦¨¬dªí´N¥i¥H
¥H«á­pºâ¦~ú¥b¦~ú©uú©M¤ëú´N²³æ¤F
jeason

TOP

­ì¨ÓVLOOKUPÁÙ¥i³o¼Ë¥Î,¯u¬O¨ü±Ð¤F

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD