[µo°Ý] IF¤½¦¡Â²¤Æ°ÝÃD

tsuan

§Ú·Q½Ð±Ð¦U¦ì¥ý¶i:
¥Ø«e§Ú¥ÎExcel »s§@¤@¥÷¤ñ»ùªí¡A§Q¥Îmin() ¨ú±o³Ì§C­È«á¡A¦A¥ÎIF()¨ú±o¬Û¹ï¼t°Ó¦WºÙ¡A¦ý¦]¼t°Ó®a¼Æ±`¦³¥[´î±¡§Î¡A§Úªº¤½¦¡=IF(X3="","",IF(G3=X3,$E$1,IF(J3=X3,$H$1,IF(M3=X3,$K$1,IF(P3=X3,$N$1,IF(S3=X3,$Q$1,$T$1))))))¡A¦p¸I¨ì®a¼Æ¼W´î®É¡A¦Û¤v§ó§ï®É¤]³£¬Ý±o²´ªá¼º¶Ã¡A¤£ª¾¦³¨S§ó¦nªº¤è¦¡?

tsuan

¦^´_ 2# jimmuLu


    «~¶µ¬O¦³¼Æ¦Êµ§¡A¦]¦¹¤£¯à¥Î³oºØ¤è¦¡³B²z¡C

tsuan

¦^´_ 4# ANGELA


   ¤£¬O«Ü²z¸Ñ¡A¥i¥Hµy¥[¸ÑÄÀ¤@¤U¶Ü?

tsuan

¦^´_ 6# ANGELA


    ¦A½Ð°ÝANGELA :
¦A»{¯uºN·j«á¦³µyµy²z¸Ñ¨Ç¤F¡A¦ý°}¦C¤½¦¡§Ú¯uªºÁٻݦh¥[¬ã¨s¤~¦æ¡C¬O§_¥i¥H¦AÀ°§Ú§Ë¥X³Ì§C®É»ù¡B§t¦B²v¤Î±o¼Ð»ùªº°}¦C¤½¦¡©O?
Àµ¨DÀ°¦£¤F!

tsuan

·PÁª©¥D¡A§Ö¼Ö¨Ï¥Î¤¤¡C
Áö¥i±¤"³Ì§C®É»ù" ¨S¦³¾A·í¤è¦¡¡A¦ý¤w¸g§ïµ½¤Ó¦h¤F

tsuan

·P¿Eª©¥D
¥¿¬O§Ú©Ò»Ý­n¡A¦A¤]¤£¥Î·Ð´o¼t°Ó¼W´î¤F¡C
¦ý°}¦C¤½¦¡ÁÙ¯u»Ý­nÅÞ¿è°÷±j¤~§Ë±o¥X¨Ó¡C

tsuan

¦^´_ 10# ANGELA


   ª©¥D±z¦n:
¨Ï¥Î³Ì§C»ù¤½¦¡®É¡A¦]³]©w0,9000¡A¦]¦¹·|²£¥Í¦p¥þ³¡µL¤H³ø»ù®É·|±a¥X9000ªº¼Æ¦r¡A©Î¦³¶W¥X9000®É¥çµLªk±a¥X¥¿½T¼Æ¦r¡A¤£ª¾¬O§_¦³¸Ñ?

tsuan

·PÁª©¥D´£¿ô¡A¤w¸g­×¥¿§¹¦¨¡C

tsuan

¦^´_ 8# ANGELA


    ¦A½Ð±Ðª©¥D¡A§Ú§Æ±æ§t¦B²v=0 ®É¤£Åã¥Ü¦]¦¹±N¤½¦¡­×¥¿¬°
=IF(AA11="","",IF(INDIRECT("rc"&5+(MATCH(AA11,N(OFFSET(G11,,(ROW(INDIRECT("$1:$"&COUNTA(E$2:W$2)))-1)*3)),)-1)*3,)=0,"",INDIRECT("rc"&5+(MATCH(AA11,N(OFFSET(G11,,(ROW(INDIRECT("$1:$"&COUNTA(E$2:W$2)))-1)*3)),)-1)*3,)))
§¡·|Åã¥ÜCOUNTA³¡¥÷¤½¦¡¿ù»~¡A¤£ª¾¤½¦¡­þ¸Ì¦³»~¡A°È½Ð«ü¾É!

tsuan

»{¯u¬Ý¹L¬Ý¨Ó¤w¸g¤£¯à´î¤Ö¼h¼Æ¤F¡A¤Ï¥¿Åã¥Ü¹s¤]¨S¤°»ò°ÝÃD