²é¿´: 651  |  »Ø¸´: 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¸ö×Ö·ûÒÔÉÏ)
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] Ò»Ö¾Ô¸ÖÐÄÏ»¯Ñ§337Çóµ÷¼Á +4 niko- 2026-03-19 5/250 2026-03-20 13:49 by ´ÙÌì³É
[¿¼ÑÐ] 290Çóµ÷¼Á +4 ^O^Ø¿ 2026-03-19 4/200 2026-03-20 11:51 by ѧԱ8dgXkO
[¿¼ÑÐ] ²ÄÁÏ080500µ÷¼ÁÇóÊÕÁô +6 Ò»¿Åmeteor 2026-03-13 6/300 2026-03-20 10:41 by EBSD
[¿¼ÑÐ] ²ÄÁÏѧ˶318Çóµ÷¼Á +5 February_Feb 2026-03-19 5/250 2026-03-19 23:51 by 23Postgrad
[¿¼ÑÐ] 266Çóµ÷¼Á +5 ÑôÑôÍÛÈû 2026-03-14 10/500 2026-03-19 15:08 by ÑôÑôÍÛÈû
[¿¼ÑÐ] 287Çóµ÷¼Á +3 ³¿»èÏßÓëÐǺ£ 2026-03-19 4/200 2026-03-19 12:32 by peike
[¿¼ÑÐ] 304Çóµ÷¼Á +6 ˾¿Õ. 2026-03-18 6/300 2026-03-18 23:03 by ÐÇ¿ÕÐÇÔÂ
[¿¼ÑÐ] Ò»Ö¾Ô¸ÎäÀí²ÄÁÏ305·ÖÇóµ÷¼Á +5 ÏëÉϰ¶µÄÀðÓã 2026-03-18 6/300 2026-03-18 17:53 by Î޼ʵIJÝÔ­
[¿¼ÑÐ] 0854£¬¼ÆËã»úÀàÕÐÊÕµ÷¼Á +3 ºúÀ±ÌÀ·ÅÌÇ 2026-03-15 6/300 2026-03-18 12:09 by Éϰ¶Éϰ¶¡­¡­..
[¿¼ÑÐ] 299Çóµ÷¼Á +5 ¡÷С͸Ã÷* 2026-03-17 5/250 2026-03-18 11:49 by ¾¡Ë´Ò¢1
[¿¼ÑÐ] 280Çóµ÷¼Á +6 ¹¾ààÏþÏþ 2026-03-18 7/350 2026-03-18 11:25 by Î޼ʵIJÝÔ­
[¿¼ÑÐ] ²ÄÁÏ£¬·ÄÖ¯£¬ÉúÎ0856¡¢0710£©£¬»¯Ñ§ÕÐÉúÀ² +3 Eember. 2026-03-17 9/450 2026-03-18 10:28 by Eember.
[¿¼ÑÐ] 301Çóµ÷¼Á +9 yyÒªÉϰ¶Ñ½ 2026-03-17 9/450 2026-03-18 08:58 by Î޼ʵIJÝÔ­
[¿¼ÑÐ] 334Çóµ÷¼Á +3 Ö¾´æ¸ßÔ¶ÒâÔÚ»úÐ 2026-03-16 3/150 2026-03-18 08:34 by lm4875102
[¿¼ÑÐ] ¿¼ÑÐÇóµ÷¼Á +3 éÙËÌ. 2026-03-17 4/200 2026-03-17 21:43 by ÓÐÖ»ÀêÅ«
[¿¼ÑÐ] ҩѧ383 Çóµ÷¼Á +3 ҩѧchy 2026-03-15 4/200 2026-03-16 20:51 by Ôª×Ó^0^
[¿¼ÑÐ] 0854¿ØÖƹ¤³Ì 359Çóµ÷¼Á ¿É¿çרҵ +3 626776879 2026-03-14 9/450 2026-03-16 17:42 by 626776879
[¿¼ÑÐ] 070300»¯Ñ§Ñ§Ë¶Çóµ÷¼Á +6 Ì«Ïë½ø²½ÁË0608 2026-03-16 6/300 2026-03-16 16:13 by kykm678
[¿¼ÑÐ] 070305Çóµ÷¼Á +3 mlpqaz03 2026-03-14 4/200 2026-03-15 11:04 by peike
[¿¼ÑÐ] 297Çóµ÷¼Á +4 ѧº£Æ¯²´ 2026-03-13 4/200 2026-03-14 11:51 by ÈÈÇéɳĮ
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û