191问答库 > excel 如果A1单元格出现0123456789的时候，B2就对应显示45 56 67 78 89 90 01 12 23 34 ，这个怎么写？

excel 如果A1单元格出现0123456789的时候，B2就对应显示45 56 67 78 89 90 01 12 23 34 ，这个怎么写？

在线等待，大哥帮下我把

2024-11-19 08:49:29

推荐回答（4个）

回答1：

B2公式：
=IF(A1="","",TEXT(CHOOSE(A1+1,45,56,67,78,89,90,1,12,23,34),"00"))
或者：
=IF(A1="","",MID("45566778899001122334",A1*2+1,2))

回答2：

B1公式：
=IF(A1="","",VLOOKUP(A1,{0,"45";1,"56";2,"67";3,"78";4,"89";5,"90";6,"01";7,"12";8,"23";9,"34"},2,))
或
B1公式：=IF(A1="","",INDEX({"45","56","67","78","89","90","01","12","23","34"},A1+1))

回答3：

=if（a1=0,"45",if（a1=1,"56",if（a1=2,"67",if（a1=3,"78",if（a1=4,"89",if（a1=5,"90",if（a1=6,"01",if（a1=7,"12",if（a1=8,"23","34"））））））））））

回答4：

=if(A1="0123456789","45 56 67 78 89 90 01 12 23 34","")