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

±N­ì¨Ó¦¸§Ç­«·s±Æ¦C,¨D¬ÛÃö¤½¦¡ªº¦ù©µ°ÝÃD

¦^´_ 9# K_Wing


    E3=IF(OR(D3=1,D3=3),IF(D3=3,C3-MAX($C$3:$C$6),""),"")
    MAX($C$3:$C$6)=>§ä¥XÀç·~ÃB³Ì¤jªº¡A¥ç¥Nªí²Ä¤@¦W
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

¦^´_ 10# p212
¦^´_ 11# hugh0620
³o´X¤Ñ©ñ¸t½Ï°²
­n¤U¬P´Á¤~¯à¦^¤½¥q¸Õ¸Õ
¨ì®É¦A§iª¾¤j®aµ²ªG

TOP

¦^´_ 9# K_Wing


    E2=IF(D2=3,MAX($C$2:$C$5)-C2,"")
play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  K_Wing
ÀxÀx¦s®æE2¿é¤J
=IF(C2=LARGE(OFFSET($C$2,,,COUNTA(C:C)-1),3),C2-LARGE(OFFSET($C$2,,,COUNTA(C:C)-1),1),"")
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I
ps. ¡u´£¨Ñ½d¨ÒÀÉ¡vªº·N«ä¬°¤W¶ÇExcel®æ¦¡ªºªþ¥ó¡A¦Ó«D¶K¹Ï¡F¤£«K¤W¶Ç­ìÀɮɡA¥i³y¼ÒÀÀÀɧY¥i¡C
p212 µoªí©ó 2014-12-23 08:36
¦^´_  K_Wing
E3=IF(OR(D3=1,D3=3),IF(D3=3,C3-MAX($C$3:$C$6),""),"")
    MAX($C$3:$C$6)=>§ä¥XÀç·~ÃB³Ì¤jªº¡A¥ç¥Nªí²Ä¤@¦W
hugh0620 µoªí©ó 2014-12-23 12:12
¦^´_  K_Wing
    E2=IF(D2=3,MAX($C$2C$5)-C2,"")

Hsieh µoªí©ó 2014-12-23 23:55

·PÁ¦U¦ì¥S§Ì¿ãÅDÀ°¦£
¦³Ãö¤½¦¡¤w¥æ¦ÑÁó¿ï¾Ü
²Ö­p¼Wªø.gif
¨C¶µ¤½¦¡³£¯à­pºâ¥X¬ÛÃöµ²ªG
¦ÑÁó¦Û¦æ¿é¤J¬ÛÃö»È½X
³Ì«á¿ï¨ú¤F·í¨â¶¡ ¤½¥q¦P®É±Æ¦b²Ä¤G¦W

³£¯àÅã¥Üµ²ªGªº¤½¦¡
¦A¦¸¦hÁ¦U¦ì¼ö¤ßÀ°¦£
°J¤ß·PÁÂ

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD