张肉包没有馅
2024-06-26 22:31:26
最佳回答
1在单元格a2中输入01/02×03-04+05#062a3单元格输入公式一直下拉=if(a2="","",if(--right(a2,2)<33,mid(a2,1,12)&text(mid(a2,13,2)+1,"00")&"#"&text(right(a2,2)+1,"00"),if(and(--mid(a2,1,2)=28,--mid(a2,4,2)=29,--mid(a2,7,2)=30,--mid(a2,10,2)=31,--mid(a2,13,2)=32,--right(a2,2)=33),"",if(and(--mid(a2,1,2)<28,--mid(a2,4,2)=29,--mid(a2,7,2)=30,--mid(a2,10,2)=31,--mid(a2,13,2)=32,--right(a2,2)=33),text(left(a2,2)+1,"00")&"/"&text(left(a2,2)+2,"00")&"×"&text(left(a2,2)+3,"00")&"-"&text(left(a2,2)+4,"00")&"+"&text(left(a2,2)+5,"00")&"#"&text(left(a2,2)+6,"00"),if(and(--mid(a2,4,2)<29,--mid(a2,7,2)=30,--mid(a2,10,2)=31,--mid(a2,13,2)=32,--right(a2,2)=33),text(left(a2,2),"00")&"/"&text(mid(a2,4,2)+1,"00")&"×"&text(mid(a2,4,2)+2,"00")&"-"&text(mid(a2,4,2)+3,"00")&"+"&text(mid(a2,4,2)+4,"00")&"#"&text(mid(a2,4,2)+5,"00"),if(and(--mid(a2,7,2)<30,--mid(a2,10,2)=31,--mid(a2,13,2)=32,--right(a2,2)=33),mid(a2,1,6)&text(mid(a2,7,2)+1,"00")&"-"&text(mid(a2,7,2)+2,"00")&"+"&text(mid(a2,7,2)+3,"00")&"#"&text(mid(a2,7,2)+4,"00"),if(and(--mid(a2,10,2)<31,--mid(a2,13,2)=32,--right(a2,2)=33),mid(a2,1,9)&text(mid(a2,10,2)+1,"00")&"+"&text(mid(a2,10,2)+2,"00")&"#"&text(mid(a2,10,2)+3,"00"),if(and(--mid(a2,13,2)<32,--right(a2,2)=33),mid(a2,1,12)&text(mid(a2,13,2)+1,"00")&"#"&text(mid(a2,13,2)+1,"00")))))))))3b2单元格输入公式一直右拉在下拉=if(a2="","",if(--right(a2,2)=33,"",left(a2,14)&"#"&text(right(a2,2)+1,"00"))),就会显示出所有的排列组合end3相关内容非法爬取自百度经验 20210311