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

[µo°Ý]¤ÀÃþ¾ã²z°t¤è»Ý­n¶q

[µo°Ý]¤ÀÃþ¾ã²z°t¤è»Ý­n¶q

¥»©«³Ì«á¥Ñ rakefrank ©ó 2013-9-5 21:22 ½s¿è

A1=G(a+b)(1.2+2)
B1=H(a+b+c)(3+1+4.2)
C1=K{a+(b+c)}{1.5+(2+2)}
D1=L{a+(b+c)}{1.5+(2+2)}

³o¬OG¡BH¡BK¡BL°t¤èªºªí¥Üªk
¦³¿ìªk±Na¡Bb¡Bc¡Bd­n¦h¤Ö¶q¾ã²z¥[Á`¶Ü¡H
½Ð¨ó§UÀ°¦£¡A·PÁ¡I

°t¤è.rar (1.65 KB)

¥»©«³Ì«á¥Ñ p212 ©ó 2013-9-6 09:38 ½s¿è

¦^´_ 1# rakefrank
´Nªþ¥óÀɦӨ¥¡A±z­nªºµ²ªG¤£¬O¤w¾ã²z¦n¤F¶Ü¡H (­Y´N°t¤è¶µ¥ØG¡BH¡BK¡BL...¥i¯àÂX®i¶µ¥Ø¼Æ¦Ó¨¥¡A¨Ì±zªº¤èªk¥u­n±N¡uÁ`»Ý­n¶q¡v¦C¸m©óa¡Bb¡Bc¡Bd¦C¤§¤W§Y¥i)
¥i¥H¦A±N°ÝÃD´y­z¤@¤U¶Ü¡HÅý¤j¹Ù¨à¤@°_¬ã¨s§a¡I
ÁÂÁ¡I

TOP

§Aªº³¯­z¦³ÂI©â¶H¡A¥i¥H¦A»¡ªº²M·¡¤@ÂI¶Ü¡H
¦]¬°´N§Aªºªí¨Ó¬Ý¡A§A³£¤w¸g¥[Á`¦n¤F¡A¤£©ú¥Õ§AÁٻݭn¤°»ò¨ä¥L¥\¯à¡H

TOP

¥»©«³Ì«á¥Ñ rakefrank ©ó 2013-9-6 13:57 ½s¿è

¦]¬°¥u¦³4µ§¸ê®Æ§Ú¥i¥H°¨¤W¾ã²z¦n
¦ý¬O¹ê»Ú¤W°t¤è¤j·§¦³¤W¸UºØ
¦Ó¥B¦¨¥÷¤]¤£¥u4ºØ
¦³¤°»ò¿ìªk¥i¥HÅýEXCEL¸ÑŪ°t¤è¦Ó¦Û°Ê­pºâ¦¨¥÷
¸ê®Æ®æ¦¡¨Ó·½¬OtxtÀÉ

§Æ±æ¯à¦Û°Ê¤À¥X¦¨¥÷
·PÁ¤j®aªº«ü¾É

TOP

°t¤è2.rar (2.2 KB)
ªþ¥óB2~B5¡BC2~C5´N¬O§Ú¹Á¸Õ­n±N¦¨¥÷¤ñ¨Ò¸ÑŪ
¦³§ó¦n¡B§ó¦³®Ä²vªº¤èªk¶Ü

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2013-9-6 20:51 ½s¿è

§âC2¤½¦¡§ï¦¨=SUBSTITUTE(SUBSTITUTE(MID(A2,IF(ISERROR(SEARCH("}",A2,1)),SEARCH(")",A2,1),SEARCH("}",A2,1))+2,LEN(A2)-IF(ISERROR(SEARCH("}",A2,1)),SEARCH(")",A2,1),SEARCH("}",A2,1))-2),"(",),")",)©¹¤Ucopy
C13=--MID(SUBSTITUTE($C2,"+",REPT(" ",50)),1,50)
D13=--MID(SUBSTITUTE(C2,"+",REPT(" ",50)),51,50)
E13=IF((LEN(C2)-LEN(SUBSTITUTE(C2,"+",)))<2,"",--MID(SUBSTITUTE($C2,"+",REPT(" ",50)),101,50))
F13=IF((LEN(C2)-LEN(SUBSTITUTE(C2,"+",)))<3,"",--MID(SUBSTITUTE($C2,"+",REPT(" ",50)),151,50))
B2=IF(ISERROR(SEARCH("{",A2,1)),MID(A2,SEARCH("(",A2,1),SEARCH(")",A2,1)-SEARCH("(",A2,1)+1),MID(A2,SEARCH("{",A2,1),SEARCH("}",A2,1)-SEARCH("{",A2,1)+1))

TOP

¦^´_ 6# ANGELA

·PÁ§A´£¨Ñªº«Øij
­ì¨ÓSUBSTITUTE©MREPT³o»ò¦n¥Î

TOP

¦A½Ð±Ð¤@¤U¥ÎSUBSTITUTE§â¦r¦êÅܦ¨B2=a+b+c+d«á
·QÄ~Äò¤À¦¨C2=a
                      D2=b
                      E2=c
                      F2=d
³Â·Ð«ü¾É

TOP

¦^´_ 8# rakefrank

    B2=a+b+c+d
    C2=TRIM(MID(SUBSTITUTE($B2,"+",REPT(" ",50)),COLUMN(A1)*50-49,50))¦V¥kcopy

TOP

¦^´_ 9# ANGELA


    ·PÁ«ü¾É

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD