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

[µo°Ý] ½Ð°Ý¥­§¡¦~¸êªº­pºâ

[µo°Ý] ½Ð°Ý¥­§¡¦~¸êªº­pºâ

¦U¦ì«e½ú¡G

¸ê®Æ±q¨t²ÎÂà¤U¨Ó¤§«á¡A¤p§Ì±N¸ê®Æ§@¦¨¦~¸ê¤§«á
¤@®É¶¡¤£ª¾¹D±q¦ó¤U¤â¥h­pºâ¥­§¡¦~¸ê

¥i§_½Ð¦U¦ì¤j¤j±Ð¾É¤@¤U

·P®¦

°²¦p¦~¸ê©ñ¦b A1:A10
¥­§¡¦~¸ê =AVERAGE(A1:A10)
©Î =SUM(A1:A10)/10
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦A½Ð°Ý¤j¤j
­Y¬O¦~¸êªº§Î¦¡¬°
"10¦~11­Ó¤ë"  

³oºØÃþ«¬ªº¡A¥ÎAVERAGE±o¤£¥X¨Ó...
³o¼Ë¸Ó¦p¦ó¥h­pºâ¥­§¡¦~¸ê

TOP

¦^´_ 3# kakala0513

­Y¬O¦~¸êªº§Î¦¡¬° A1= "10¦~11­Ó¤ë"
»Ý­n¥ýÂà´«¬°¼Æ¦r®æ¦¡¡A¤½¦¡¦p¤U
B1=--(IF(ISERR(FIND("¦~",A1)),"0 ","")&SUBSTITUTE(SUBSTITUTE(A1,"¦~"," "),"­Ó¤ë","/12"))

¦A¨Ï¥ÎAVERAGE¨ç¼Æ
C1=AVERAGE(B1:B3)

­Y¤£­n»²§UÄæ¤]¥i¥H±N¤W¦¡§ï¬°°}¦C¤½¦¡«¬ºA
D1 =AVERAGE(--(IF(ISERR(FIND("¦~",A1:A3)),"0 ","")&SUBSTITUTE(SUBSTITUTE(A1:A3,"¦~"," "),"­Ó¤ë","/12")))
»Ý¥Î°}¦C¿é¤J(CTRL+SHIFT+ENTER¤T«Ø»ô«ö)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ Bodhidharma ©ó 2013-6-4 12:54 ½s¿è

¦^´_ 4# ML089

--"a b/c"=a+b/c   (a,b¬°¥¿¾ã¼Æ©Î0,c¬°¥¿¾ã¼Æ)
³oºØ¤å¦rÂà¼Æ¦rªº¤è¦¡ÁÙ¬O²Ä¤@¦¸¬Ý¨ì¡A¨ü±Ð¡I
µy·L¸Õ¤F¤@¤U¡A--"-a b/c"=-a-b/c
·Q½Ð±Ð¬O§_ÁÙ¦³Ãþ¦üªº®æ¦¡¡H

TOP

¦^´_ 5# Bodhidharma

> --"a b/c"=a+b/c   (a,b¬°¥¿¾ã¼Æ©Î0,c¬°¥¿¾ã¼Æ)
> ³oºØ¤å¦rÂà¼Æ¦rªº¤è¦¡ÁÙ¬O²Ä¤@¦¸¬Ý¨ì¡A¨ü±Ð¡I
> µy·L¸Õ¤F¤@¤U¡A--"-a b/c"=-a-b/c
> ·Q½Ð±Ð¬O§_ÁÙ¦³Ãþ¦üªº®æ¦¡¡H
   
°ò¥»®æ¦¡¬O "a b/c"  ¡Aa»Pb¤§¶¡¬°ªÅ®æ
1.2 = 1 1/5
-1.2 = -1 1/5

¥i¥H¥ÑÀx¦s®æ®æ¦¡¤¤ªº¤À¼Æ¥hÆ[¹î®æ¦¡ªº°ò¥»³]©w¡A¤@¯ë±`¥Î¦b¤å¦r«¬ºA¤é´Á»P®É¶¡ªº©î¸Ñ¤Î¥[´î
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

·PÁ¤j¤jªº¦^ÂÐ....

¸Ñ¨M§xÂZ¤p§Ì³\¤[ªº°ÝÃD

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD