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

[µo°Ý] ¦h±ø¥ó­pºâ¥æ©ö©ú²Ó

¦^´_  Andy2483
¦^´_  ­ã´£³¡ªL
·PÁÂAndy¤j§â¥i¯à©Ê³£·Q¶i¥h¤F.....
¤]·PÁ­ã¤j¦A¤TÀ°¦£!!
´ú¸Õµo²{¦³ ...
shuo1125 µoªí©ó 2024-1-20 08:46



If Brr(x + 4)(M, 0) = 0 And M <= Mx Then Brr(x + 4)(M, 0) = Brr(x + 4)(M - 1, 0)  
§R¥h"³Ì¤j¤ë¥÷"ªº§P§O§Y¥i!!!
¦ý¬O,,³o¼Ëªº¼Æ¾Ú¬O¥¢¯uªº!!! ¥¼¨Ó¦¡¾lÃB???

TOP

¦^´_ 41# ­ã´£³¡ªL
­ã¤j¦n~
And M <= Mx¸Ó¬q¬O¥²¶·­n¦s¦bªº..
Brr(x + 4)(M, 0) = 0 ³o¬q¤@¶}©l¦³·Q¨ì¡A¦ý§Ú«ç¸Õ³£¥X¤£¨Ó...
±z²K¼WM,Mx¤Î§PÂ_¦¡Åý¸ê®Æ§ó§¹µ½...¥u¬O¥H¤Uª¬ªp·|¦³°ÝÃD....
(¤@)·í¸Ó¤ë¥æ©ö«á¾lÃB­è¦n¬°0¡A©¹«á¬ÒµLµo¥Í¥æ©ö¡C
(¤G)1¤ë¦³¥æ©ö¡A2-12¤ë³£µL¥æ©ö¡C
¥H¤W¡A¤£ª¾¹D«ç¸Ñ....ÁÂÁ­ã¤j!!!

TOP

¦^´_ 42# shuo1125


­Y¥u°O¿ý¨ì"³Ì¤j¤ë¥÷"¬°¤î, ¬Ý38#ªº¸É¥R~~Mx¦b¤U¦¸¦^°é«e­nÂk¹s

TOP

¥»©«³Ì«á¥Ñ Andy2483 ©ó 2024-1-20 11:08 ½s¿è

¦^´_ 41# ­ã´£³¡ªL
¦^´_ 42# shuo1125


    ÁÂÁ ­ã´£³¡ªL«e½ú
½Ð±Ð ­ã´£³¡ªL«e½ú:
AV20ªº¤½¦¡­n«ç»ò¤U¤~¯à¦bAV20Åã¥Ü 8686996 ,¦Ó¤£¬O0,  ©ÎªÌVBA­n«ç»ò§ï¤~¯àÅýAV20¶ñ¤J³Ì«á¦~«×¾lÃB 8686996
§Ú²q¼Ó¥Dªº»Ý¨DÀ³¸Ó¬O³o­Ó
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 42# shuo1125
©êºp§ó¥¿¤@¤U¡K
¡]¤G¡^³o­Ó¬ö¿ý³Ì¤j¤ë´N¤£·|¦³¸Ó°ÝÃD
¤]ÁÂÁÂAndy¤j´£°Ý¡A·PÁ¡I¡I

TOP

¦^´_ 44# Andy2483

¥u¬O¤@­Ó§PÂ_//
Xl0000108_TESTv03.rar (396 KB)

TOP

¥»©«³Ì«á¥Ñ Andy2483 ©ó 2024-1-20 12:39 ½s¿è
If Brr(x + 4)(M, 0) = 0 And M
­ã´£³¡ªL µoªí©ó 2024-1-20 09:20



    ÁÂÁ«e½ú,¦pªG©Óŧ«e¤@­Ó¤ëªº¾lÃB¬O¥¢¯u¤F
¦p¤U©Ò¥ÜVBA«ç»ò³]­p²Ä20¦Cªº­È

°²³]1049124¤§«áªº9¤ë­è¦n¾lÃB¬O0¦Ó¥B10~12¤ëµL¥æ©ö,20¦C­n¼g¤J0
°²³]8686996¤§«áªº12¤ë¬OµL¥æ©ö ,20¦C­n¼g¤J8686996
¼Ó¥DÀ³¸Ó¬O­nAV20~BF20§e²{¨C¶µªº¦~«×³Ì«á¾lÃB,¦pªGVBA°õ¦æ§¹«á¦A¤U¤½¦¡§ì¾lÃB·|¦³°ÝÃD,©Ò¥HÀ³¸Ó­n¦bVBA§âAV20~BF20¼g¤J³Ì«á¾lÃB
ÁÂÁ«e½ú«ü¾É
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2024-1-20 13:07 ½s¿è

¦^´_ 47# Andy2483


¨º¤@¦æ¬O¤½¦¡//
=IF(OR(AV8:AV19,0),LOOKUP(1,0/AV8:AV19,AV8:AV19),0)

TOP

¥»©«³Ì«á¥Ñ Andy2483 ©ó 2024-1-20 12:58 ½s¿è

¦^´_ 48# ­ã´£³¡ªL


    AV20~BF20§e²{¨C¶µªº¦~«×³Ì«á¾lÃB,¦pªGVBA°õ¦æ§¹«á¦A¤U¤½¦¡§ì¾lÃB·|¦³°ÝÃD,©Ò¥HÀ³¸Ó­n¦bVBA§âAV20~BF20¼g¤J³Ì«á¾lÃB

¤£¦n·N«ä°Ý±o¤£¦n
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2024-1-20 13:10 ½s¿è

¦^´_ 49# Andy2483


¤½¦¡¬O¹w¥ý¸m¤J, ¤£¥Îµ{¦¡¥h¶ñ,  ¦p¨ä¥¦Äæ¦ìªº SUM ¤½¦¡
Xl0000108_TESTv03.rar (397.09 KB)

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD