
数字1至11在这十一个数字中任意五个号码组合在一起每组号码里不可以有重复的号码一共可以组成多少组号 70
数字1至11在这十一个数字中任意五个号码组合在一起每组号码里不可以有重复的号码一共可以组成多少组号码,求大神帮忙,谢了...
数字1至11在这十一个数字中任意五个号码组合在一起每组号码里不可以有重复的号码一共可以组成多少组号码,求大神帮忙,谢了
展开
3个回答
展开全部
可以组合462组不重复的,简单得不能在简单了,1到11个数字,5个组合成一组,不重复,如果没猜错是11选5
下面就介绍下实现方法:为了能更好得取值,让数字自动变换,我用了其它符号连接字符,
假如B3=1/2×3-4+5 (也就是你说得5个一组合)
B4
公式向下拉=IF(B3="","",IF(--RIGHT(B3,2)<11,LEFT(B3,5)&"-"&
MID(B3,FIND("-",B3)+1,FIND("+",B3)-FIND("-",B3)-1)+1&"+"&MID(B3,FIND("-",B3)+1,FIND("+",B3)-FIND("-",B3)-1)+2,IF(AND(--LEFT(B3,1)=7,--MID(B3,3,1)=8,--MID(B3,5,1)=9,--MID(B3,7,2)=10,--RIGHT(B3,2)=11),"",IF(AND(--LEFT(B3,1)<7,--MID(B3,3,1)=8,--MID(B3,5,1)=9,--MID(B3,7,2)=10,--RIGHT(B3,2)=11),LEFT(B3,1)+1&"/"&LEFT(B3,1)+2&"×"&LEFT(B3,1)+3&"-"&LEFT(B3,1)+4&"+"&LEFT(B3,1)+5,IF(AND(--MID(B3,3,1)<8,--MID(B3,5,1)=9,--MID(B3,7,2)=10,--RIGHT(B3,2)=11),LEFT(B3,1)&"/"&MID(B3,FIND("/",B3)+1,FIND("×",B3)-FIND("/",B3)-1)+1&"×"&MID(B3,FIND("/",B3)+1,FIND("×",B3)-FIND("/",B3)-1)+2&"-"&MID(B3,FIND("/",B3)+1,FIND("×",B3)-FIND("/",B3)-1)+3&"+"&MID(B3,FIND("/",B3)+1,FIND("×",B3)-FIND("/",B3)-1)+4,IF(AND(--MID(B3,FIND("×",B3)+1,FIND("-",B3)-FIND("×",B3)-1)<9,--MID(B3,FIND("-",B3)+1,FIND("+",B3)-FIND("-",B3)-1)=10,--RIGHT(B3,2)=11),LEFT(B3,4)&MID(B3,FIND("×",B3)+1,FIND("-",B3)-FIND("×",B3)-1)+1&"-"&MID(B3,FIND("×",B3)+1,FIND("-",B3)-FIND("×",B3)-1)+2&"+"&MID(B3,FIND("×",B3)+1,FIND("-",B3)-FIND("×",B3)-1)+3,))))))
C3公式向右拉在向下拉=IF(B3="","",IF(--RIGHT(B3,2)=11,"",LEFT(B3,8)&--RIGHT(B3,2)+1))
下面就介绍下实现方法:为了能更好得取值,让数字自动变换,我用了其它符号连接字符,
假如B3=1/2×3-4+5 (也就是你说得5个一组合)
B4
公式向下拉=IF(B3="","",IF(--RIGHT(B3,2)<11,LEFT(B3,5)&"-"&
MID(B3,FIND("-",B3)+1,FIND("+",B3)-FIND("-",B3)-1)+1&"+"&MID(B3,FIND("-",B3)+1,FIND("+",B3)-FIND("-",B3)-1)+2,IF(AND(--LEFT(B3,1)=7,--MID(B3,3,1)=8,--MID(B3,5,1)=9,--MID(B3,7,2)=10,--RIGHT(B3,2)=11),"",IF(AND(--LEFT(B3,1)<7,--MID(B3,3,1)=8,--MID(B3,5,1)=9,--MID(B3,7,2)=10,--RIGHT(B3,2)=11),LEFT(B3,1)+1&"/"&LEFT(B3,1)+2&"×"&LEFT(B3,1)+3&"-"&LEFT(B3,1)+4&"+"&LEFT(B3,1)+5,IF(AND(--MID(B3,3,1)<8,--MID(B3,5,1)=9,--MID(B3,7,2)=10,--RIGHT(B3,2)=11),LEFT(B3,1)&"/"&MID(B3,FIND("/",B3)+1,FIND("×",B3)-FIND("/",B3)-1)+1&"×"&MID(B3,FIND("/",B3)+1,FIND("×",B3)-FIND("/",B3)-1)+2&"-"&MID(B3,FIND("/",B3)+1,FIND("×",B3)-FIND("/",B3)-1)+3&"+"&MID(B3,FIND("/",B3)+1,FIND("×",B3)-FIND("/",B3)-1)+4,IF(AND(--MID(B3,FIND("×",B3)+1,FIND("-",B3)-FIND("×",B3)-1)<9,--MID(B3,FIND("-",B3)+1,FIND("+",B3)-FIND("-",B3)-1)=10,--RIGHT(B3,2)=11),LEFT(B3,4)&MID(B3,FIND("×",B3)+1,FIND("-",B3)-FIND("×",B3)-1)+1&"-"&MID(B3,FIND("×",B3)+1,FIND("-",B3)-FIND("×",B3)-1)+2&"+"&MID(B3,FIND("×",B3)+1,FIND("-",B3)-FIND("×",B3)-1)+3,))))))
C3公式向右拉在向下拉=IF(B3="","",IF(--RIGHT(B3,2)=11,"",LEFT(B3,8)&--RIGHT(B3,2)+1))
追问
可以帮忙把这462号码做个图表吗,谢谢
追答
不好意思,我现在没有时间啊
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询