2022-04-10 23:06发布
1、在D1单元格输入以下公式，然后向下填充公式=IF(--MID(A1,1,1)
1、在D1单元格输入以下公式，然后向下填充公式=IF(--MID(A1,1,1)<5,"小","大")&IF(--MID(A1,2,1)<5,"小","大")&IF(--MID(A1,3,1)<5,"小","大")&IF(--MID(A1,4,1)<5,"小","大")&IF(--MID(A1,5,1)<5,"小","大")公式将A1单元格的每个数字拆分取出，通过条件函数建立比较，分别返回对应的大小2、在F1单元格输入以下公式，然后向下填充公式=IF(MOD(MID(A1,1,1),2),"单","双")&IF(MOD(MID(A1,2,1),2),"单","双")&IF(MOD(MID(A1,3,1),2),"单","双")&IF(MOD(MID(A1,4,1),2),"单","双")&IF(MOD(MID(A1,5,1),2),"单","双")公式将A1单元格的每个数字拆分取出，通过建立被2整除余数，条件函数分别返回对应的双单
最暴力的方法，假设数据在A1，将下面公式复制到D1，F1即可D1的公式：=IF(VALUE(MID(A1,1,1))>4,"大","小")&IF(VALUE(MID(A1,2,1))>4,"大","小")&IF(VALUE(MID(A1,3,1))>4,"大","小")&IF(VALUE(MID(A1,4,1))>4,"大","小")&IF(VALUE(MID(A1,5,1))>4,"大","小")F1的公式：=IF(MOD(MID(A1,1,1),2)=0,"双","单")&IF(MOD(MID(A1,2,1),2)=0,"双","单")&IF(MOD(MID(A1,3,1),2)=0,"双","单")&IF(MOD(MID(A1,4,1),2)=0,"双","单")&IF(MOD(MID(A1,5,1),2)=0,"双","单")
最多设置5个标签!
{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','http://hwaiwenda.com/data/attach/logo/logo.png', '推荐 汪木彭曼冬 的问题《五位数字怎么用excel公式表示大小单双》','https://hwaiwenda.com/answer/1845/1834.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
1、在D1单元格输入以下公式，然后向下填充公式
=IF(--MID(A1,1,1)<5,"小","大")&IF(--MID(A1,2,1)<5,"小","大")&IF(--MID(A1,3,1)<5,"小","大")&IF(--MID(A1,4,1)<5,"小","大")&IF(--MID(A1,5,1)<5,"小","大")
公式将A1单元格的每个数字拆分取出，通过条件函数建立比较，分别返回对应的大小
2、在F1单元格输入以下公式，然后向下填充公式
=IF(MOD(MID(A1,1,1),2),"单","双")&IF(MOD(MID(A1,2,1),2),"单","双")&IF(MOD(MID(A1,3,1),2),"单","双")&IF(MOD(MID(A1,4,1),2),"单","双")&IF(MOD(MID(A1,5,1),2),"单","双")
公式将A1单元格的每个数字拆分取出，通过建立被2整除余数，条件函数分别返回对应的双单
1、在D1单元格输入以下公式，然后向下填充公式
=IF(--MID(A1,1,1)<5,"小","大")&IF(--MID(A1,2,1)<5,"小","大")&IF(--MID(A1,3,1)<5,"小","大")&IF(--MID(A1,4,1)<5,"小","大")&IF(--MID(A1,5,1)<5,"小","大")
公式将A1单元格的每个数字拆分取出，通过条件函数建立比较，分别返回对应的大小
2、在F1单元格输入以下公式，然后向下填充公式
=IF(MOD(MID(A1,1,1),2),"单","双")&IF(MOD(MID(A1,2,1),2),"单","双")&IF(MOD(MID(A1,3,1),2),"单","双")&IF(MOD(MID(A1,4,1),2),"单","双")&IF(MOD(MID(A1,5,1),2),"单","双")
公式将A1单元格的每个数字拆分取出，通过建立被2整除余数，条件函数分别返回对应的双单
1、在D1单元格输入以下公式，然后向下填充公式
=IF(--MID(A1,1,1)<5,"小","大")&IF(--MID(A1,2,1)<5,"小","大")&IF(--MID(A1,3,1)<5,"小","大")&IF(--MID(A1,4,1)<5,"小","大")&IF(--MID(A1,5,1)<5,"小","大")
公式将A1单元格的每个数字拆分取出，通过条件函数建立比较，分别返回对应的大小
2、在F1单元格输入以下公式，然后向下填充公式
=IF(MOD(MID(A1,1,1),2),"单","双")&IF(MOD(MID(A1,2,1),2),"单","双")&IF(MOD(MID(A1,3,1),2),"单","双")&IF(MOD(MID(A1,4,1),2),"单","双")&IF(MOD(MID(A1,5,1),2),"单","双")
公式将A1单元格的每个数字拆分取出，通过建立被2整除余数，条件函数分别返回对应的双单
最暴力的方法，假设数据在A1，将下面公式复制到D1，F1即可
D1的公式：
=IF(VALUE(
MID(A1,1,1))>4,"大","小")&IF(VALUE(
MID(A1,2,1))>4,"大","小")&IF(VALUE(
MID(A1,3,1))>4,"大","小")&IF(VALUE(
MID(A1,4,1))>4,"大","小")&IF(VALUE(
MID(A1,5,1))>4,"大","小")
F1的公式：
=IF(MOD(MID(A1,1,1),2)=0,"双","单")&IF(MOD(MID(A1,2,1),2)=0,"双","单")&IF(MOD(MID(A1,3,1),2)=0,"双","单")&IF(MOD(MID(A1,4,1),2)=0,"双","单")&IF(MOD(MID(A1,5,1),2)=0,"双","单")
一周热门 更多>