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

[µo°Ý] IF¥i¥H°µÂù­«§PÂ_¶Ü?

I17=IF(H17,IF((G17="¦h")*(F16<F17)+(G17="ªÅ")*(F16>F17),G17,0),I16)

½Ð°Ý¤@¤U ()¸Ì­±ªºªF¦è¦n¹³¤£¬O¼Æ­È if¸Ì­±¥Î* ¸ò + ¤À§O¥Nªí¤°»ò¥\¯à
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2010-7-1 00:07 ½s¿è

*¬°"¥B"ªº·N«ä
+¬°"©Î"ªº·N«ä

*­n¤GªÌ³£¬°"¯u"¤~·|¬°¯u
+¤GªÌ¨ä¤¤¥ô¤@¬°"¯u"³£·|¬°¯u
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¸Õ¹L¤§«áµo²{¦pªO¤j©Ò¨¥
¥L¸òAND ¤Î ORªº¥Îªk¨Ï¥Î¤W¦³¤°»ò®t²§¶Ü
¦pªG¥ÎAND¤ÎOR¼g IF(OR(AND(A1>5,A1<10),AND(B1<50,B1>10)),"¯u","")
´«¦¨* ¤Î +
­n«ç»òªí¹F?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 13# freeffly


    =IF(((A1>5)*(A1<10))+((B1<50)*(B1>10)),"¯u","")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 13# freeffly


AND - "¥B"ªº·N«ä ¦P"*"
OR - "©Î"ªº·N«ä ¦P"+"

TOP

ÁÂÁ¤j¤j¦^½Æ
·Pı¥Î* ¸ò+ ·|¦³¤ñ¸û¦hªº( )
¤£ª¾¹D·|¨ç¼Æªºªø«×¦³¨S¦³¼vÅT
¥H«e´¿¸g¼g¹L³Q§P©w¨ç¼Æ¤Óªø¨S¿ìªkÄ~Äò¼g
()¤Ó¦h·|³o¼Ë¶Ü?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

ÁÂÁ¤j¤j¦^½Æ
·Pı¥Î* ¸ò+ ·|¦³¤ñ¸û¦hªº( )
¤£ª¾¹D·|¨ç¼Æªºªø«×¦³¨S¦³¼vÅT
¥H«e´¿¸g¼g¹L³Q§P©w¨ç¼Æ¤Óªø¨S ...
freeffly µoªí©ó 2010-7-4 18:32



¨Ï¥Î¨ç¼Æ¦³¨Ç°ò¥»­­¨î
¦p¨Ï¥Îif¤£¥i¶W¹L¤C¼h,¨Ï¥Îsum®Énumber¤£¥i¶W¹L30­Óµ¥µ¥
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¦^´_ 17# asimov


    ­n¬ð¯}IFªº7¼h­­¨î¥i¤À¬q¦A§Q¥Î+Åý¼h¼Æ©µ¦ù
SUMªº30­Ó¤Þ¼Æ¥i¥Î³sÄò½d³ò©Î°}¦C¬ð¯}
¸m©ó¤½¦¡ªø«×¤j©ó256¦r¤¸¥i¯à¾DEXCEL©Úµ´±µ¨ü¥i·f°t©w¸q¦WºÙ¸Ñ¨M
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  asimov


    ­n¬ð¯}IFªº7¼h­­¨î¥i¤À¬q¦A§Q¥Î+Åý¼h¼Æ©µ¦ù
SUMªº30­Ó¤Þ¼Æ¥i¥Î³sÄò½d³ò©Î°}¦C¬ð¯} ...
Hsieh µoªí©ó 2010-7-5 19:09


ifªº¤À¬q¦³¨Ò¤l¥i¥H¤À¨É¶Ü
§Ú³£¬O¦b¤£¦PÀx¦s®æ°µ§¹§PÂ_
µM«á¥Î³Ì²×­nÅã¥ÜªºÀx¦s®æ¥h¿ï¨ú¨ä¥L§PÂ_ª±ªºÀx¦s®æ
¥Î³oºØ¤gªk·Ò¿ûªº¤è¦¡¤À¬q
«Ü¦n©_¤j¤jªº¤À¬q«ç»ò¨Ï¥Î
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¥»©«³Ì«á¥Ñ asimov ©ó 2010-7-5 22:49 ½s¿è
    ­n¬ð¯}IFªº7¼h­­¨î¥i¤À¬q¦A§Q¥Î+Åý¼h¼Æ©µ¦ù
SUMªº30­Ó¤Þ¼Æ¥i¥Î³sÄò½d³ò©Î°}¦C¬ð¯} ...
Hsieh µoªí©ó 2010-7-5 19:09



Hsiehª©¥D»¡±o¨S¿ù
¥i¥H¹B¥Î¦UºØ§Þ¥©¬ð¯}ifªº7¼h­­¨î
¨Ò¦p=if(and(±ø¥ó¤@,±ø¥ó¤G),.....
    =if(or(±ø¥ó¤@,±ø¥ó¤G),.....
    ©Î¬O¥æ¤e¹B¥Î=if(and(or(.....),and(......)),.....

SUM¯uªº¥u¯à¦³30­Ónumber¶Ü
¸Õ¸Õªþ¥ó" SUMªº²×·¥¬ð¯}.zip (3.01 KB) "
±z·|µo²{ÀH®É¥Rº¡Åå©_
C17Á`¦@¥Î¤F517­Ó¦r¤¸,150­Ónumber...
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD