Znn3bq.jpeg
²é¿´: 682  |  »Ø¸´: 9
µ±Ç°Ö÷ÌâÒѾ­´æµµ¡£
¡¾ÐüÉͽð±Ò¡¿»Ø´ð±¾ÌûÎÊÌ⣬×÷ÕßDaoist½«ÔùËÍÄú 20 ¸ö½ð±Ò
µ±Ç°Ö»ÏÔʾÂú×ãÖ¸¶¨Ìõ¼þµÄ»ØÌû£¬µã»÷ÕâÀï²é¿´±¾»°ÌâµÄËùÓлØÌû

Daoist

ľ³æ (ÕýʽдÊÖ)

[ÇóÖú] ÈçºÎÓÃEXCELº¯Êý(²»°üº¬VBA±à³Ì)ÇóÈçÏÂÎÊÌ⡾ÓÐЧÆÚÖÁ2008Äê10ÔÂ10ÈÕ¡¿

ÈçºÎÓÃEXCELº¯Êý(²»°üº¬VBA±à³Ì)ÇóÈçÏÂÎÊÌâ
ÏÖÔÚÓÐn¸öÊý,´ÓÖÐÈÎÈ¡3¸öÊý,¹²ÓеÄ×éºÏÊý¿ÉÒÔÓÃEXCELº¯ÊýCOMBIN(n,3)¼ÆËã,
ÎÊÌâÊÇ:
ÈçºÎÇó³öÕâÈý¸öÊýÊÇʲô(20½ð±Ò,ÏÈ´ðÏȵÃ),Èç¹ûÊÇÈÎÈ¡5¸öÊýÄØ?

» ²ÂÄãϲ»¶

ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

afagwf

Í­³æ (³õÈëÎÄ̳)

COMBIN(n,3)¾ÍÊÇ n¸öÊýÀïÈ¡3¸ö£¬ÓжàÉÙÖÖÈ¡·¨.ÀýÈç COMBIN(10,1)£½10£¬¾ÍÊÇ10¸öÊýÀïȡһ¸ö£¬ÓÐ10ÖÖÈ¡·¨¡£ÈÎÈ¡5¸ö¾ÍÊÇCOMBIN(n,5)¡£Èý¸öÊý³Ë»ý×îСµÄÈ¡·¨Ö»ÓÐÒ»ÖÖ°¡£¬¾ÍÊÇn¸öÊýÀïÃæ3¸ö×îСµÄÊýµÄ³Ë»ý¾ø¶ÔÊÇ×îСµÄ¡£ÀýÈç 1-10µÄ10¸öÊý×Ö£¬COMBIN(10,3)µÄ×îСµÄ3¸öÊý×Ö¾ÍÊÇ1¡Á2¡Á3×îС¡£¾ßÌåÊÇÄÄ3¸öÊý¾ÍÒª¿´ÄãµÄÊý¼¯ºÏÀïµÄÄÇЩÊý×ÖÁË¡£
3Â¥2008-09-23 09:07:05
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
²é¿´È«²¿ 10 ¸ö»Ø´ð

Daoist

ľ³æ (ÕýʽдÊÖ)

²¹³ä˵Ã÷:ÒªÇó³öÕâÑùCOMBIN(n,3)¸ö×éºÏÖР   Èý¸öÊý³Ë»ý×îСµÄ×éºÏ.
2Â¥2008-09-22 15:43:19
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

Daoist

ľ³æ (ÕýʽдÊÖ)

Õân¸öÊýÊÇÓÃÌØ¶¨µÄ¹«Ê½»òº¯Êý²úÉúµÄ,¶àÉÙ²»µÈ,Èç500Íò¸ö,²»¿ÉÄÜÏàÂ¥ÉÏÄÇÑùÒ»¿´¾ÍÖªµÀ.²¢ÇÒÔÚÇ°ÃæÃ»¼ÆËã³öÒÔǰ,ÊÇûÓоßÌåÊý×ÖµÄ,ÇëÎÊÂ¥ÉÏ¿ÉÖªÈçºÎ¼ÆËã?
4Â¥2008-09-23 10:30:14
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

Daoist

ľ³æ (ÕýʽдÊÖ)

±ÈÈç²úÉún¸öÊýµÄ¹«Ê½ÊÇsum(product(1-log(2*sin(k)))),  nΪ×ÔÈ»Êý,k=1----sΪÕûÊý
5Â¥2008-09-23 10:46:31
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
²»Ó¦Öú È·¶¨»ØÌûÓ¦Öú (×¢Ò⣺ӦÖú²Å¿ÉÄܱ»½±Àø£¬µ«²»ÔÊÐí¹àË®£¬±ØÐëÌîд15¸ö×Ö·ûÒÔÉÏ)
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] Çóµ÷¼Á£¬262»úеר˶ +8 àÅyyl 2026-04-08 8/400 2026-04-12 02:31 by Çï¶¹²ËÑ¿
[ÕÒ¹¤×÷] ɽ¶«¸ßУ½Ìʦ¿¼ºË³¬¼¶ÎÞµ×Ïߣ¬Ô±¹¤¹ý²»ÏÂÈ¥À² +4 qut2026 2026-04-09 9/450 2026-04-12 00:54 by qut2026
[¿¼ÑÐ] Çóµ÷¼Á +11 ÔÂ@163.com 2026-04-07 13/650 2026-04-11 22:55 by BruceLiu320
[¿¼ÑÐ] 296Çóµ÷¼Á +6 Íô£¡£¿£¡ 2026-04-09 6/300 2026-04-11 11:25 by zhq0425
[¿¼ÑÐ] 283Çóµ÷¼Á£¬¹¤¿Æ£¡ +12 ËÕ´òË®7777 2026-04-08 12/600 2026-04-11 10:28 by ÄæË®³Ë·ç
[¿¼ÑÐ] ¹ã¶«Ê¡ 085601 329·ÖÇóµ÷¼Á +14 Eddieddd 2026-04-10 14/700 2026-04-11 09:58 by bljnqdcc
[¿¼ÑÐ] ÖÐҩѧµ÷¼Á ³õÊÔ324 +4 Ñó¸Ê¾Õ¡¢ 2026-04-10 6/300 2026-04-11 09:41 by gong120082
[¿¼ÑÐ] µ÷¼Á »¯Ñ§ 307 +21 73372112 2026-04-09 23/1150 2026-04-10 23:53 by wj165256
[¿¼ÑÐ] Ò»Ö¾Ô¸211£¬»¯Ñ§310·Ö£¬±¾¿ÆÖصãË«·Ç£¬Çóµ÷¼Á +23 ŬÁ¦·Ü¶·112 2026-04-08 23/1150 2026-04-10 23:29 by 314126402
[¿¼ÑÐ] 284Çóµ÷¼Á +19 èó@@ 2026-04-06 21/1050 2026-04-10 21:12 by zhouxiaoyu
[¿¼ÑÐ] 309Çóµ÷¼Á +14 wdhw 2026-04-10 15/750 2026-04-10 21:06 by zhouxiaoyu
[¿¼ÑÐ] ÉúÎïѧ308·ÖÇóµ÷¼Á£¨Ò»Ö¾Ô¸»ª¶«Ê¦´ó£©×ö¹ý·Ö×ÓʵÑé +8 ÏàÐűػá¹ââÍòÕ 2026-04-07 9/450 2026-04-10 21:03 by zhouxiaoyu
[ÂÛÎÄͶ¸å] mdpiСÐÞrvrʱ¼äËÄÎåÌìÁË 20+3 ¹þ¹þhigh 2026-04-08 5/250 2026-04-10 16:02 by ±±¾©À³ÒðÈóÉ«
[¿¼ÑÐ] ÉúÎïÓëÒ½Ò©273Çóµ÷¼Á +18 ÀóÌâÄÏǽ 2026-04-05 19/950 2026-04-10 08:14 by kangsm
[¿¼ÑÐ] ±¾¿ÆÖ£ÖÝ´óѧ£¬Ò»Ö¾Ô¸»ª¶«Ê¦·¶´óѧ282Çóµ÷¼Á +23 Ðܸçxtk 2026-04-07 26/1300 2026-04-09 17:17 by 18446523
[¿¼ÑÐ] 327Çóµ÷¼Á +10 Xxjc1107. 2026-04-06 11/550 2026-04-09 01:21 by lature00
[¿¼ÑÐ] 344Çóµ÷¼Á +11 κ×Óper 2026-04-07 11/550 2026-04-07 23:01 by JourneyLucky
[¿¼ÑÐ] 287·ÖÇóµ÷¼Á ÓÐרÀû¹ú½±Ò»Ö¾Ô¸¹þ¹¤´ó085406 +6 °×Ò׳½ 2026-04-06 7/350 2026-04-06 22:46 by 875465
[¿¼ÑÐ] 085405Èí¼þ¹¤³Ì301·ÖÇóµ÷¼Á£¬×¨Ë¶¿É¿çרҵ£¬ËÄÁù¼¶Òѹý +3 ¾²¾²ÏëÏë 2026-04-05 3/150 2026-04-06 15:23 by nepu_uu
[¿¼ÑÐ] ¿¼Ñе÷¼ÁÉúѰÕÒµ¼Ê¦ +3 ¹ËÕ°¿¼Ñа¡ 2026-04-05 3/150 2026-04-05 18:18 by à£à£à£0119
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û