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

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

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

TOP

¦^´_ 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§_¦³¸Ñ?

TOP

9000¨ÃµL·N«ä,¥i¥Î65536¨ú¥N
¥[­ÓIF( )¥h§PÂ_¦pªGµ²ªG¬O65536®ÉÅã¥Ü¬°""

TOP

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

TOP

¦^´_ 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°È½Ð«ü¾É!

TOP

¨Ï¥Îªº¤½¦¡¶W¥X2003ª©7¼hªº­­¨î.«DCOUNTA( )ªº°ÝÃD

TOP

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

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-9-15 17:59 ½s¿è

¦^´_ 17# tsuan


   ¤u¨ã/¿ï¶µ/À˵ø¨ú®ø¹s­Èªº¤Ä¿ï
©Î¨Ï¥Î¦Û­q®æ¦¡
0%;;
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁÂHsieh
­ì¨Ó¦Û­q®æ¦¡¥i¥H³o¼Ëª±¡A¤S¾Ç¨ì¤@©Û¤F¡C
¥H«á¥i¥H¤£¥Î¨Ï¥Î
if(a1=0,"",b1)

TOP

¦^´_ 18# Hsieh


    ½Ð°ÝHsiehª©¥D:
¨Ï¥Î 0%;; ®É¡A¦p¬°­t¼Æ®É«h¥ç¤£·|Åã¥Ü¡A¤£ª¾¦³¦ó¸Ñ?

TOP

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