EXCEL中,如果知道A1为74的两位数,用什么函数可以让它变成可以组合的三位...

发布网友发布时间：2024-10-01 15:31

共2个回答

热心网友时间：2024-10-17 21:40

用笨办法帮你做了一个,公式放入一个空单元格
=IF(LEN(A1)=1,REPT(A1,3),IF(LEN(A1)=2,REPT(LEFT(A1),3)&" "&REPT(LEFT(A1),2)&RIGHT(A1)&" "&LEFT(A1)&REPT(RIGHT(A1),2)&" "&REPT(RIGHT(A1),3)&" "&REPT(RIGHT(A1),2)&LEFT(A1)&" "&RIGHT(A1)&REPT(LEFT(A1),2),IF(LEN(A1)=3,REPT(LEFT(A1),3)&" "&REPT(LEFT(A1),2)&MID(A1,2,1)&" "&REPT(LEFT(A1),2)&RIGHT(A1)&" "&LEFT(A1)&REPT(MID(A1,2,1),2)&" "&LEFT(A1)&REPT(RIGHT(A1),2)&" "&REPT(MID(A1,2,1),3)&" "&REPT(MID(A1,2,1),2)&LEFT(A1)&" "&REPT(MID(A1,2,1),2)&RIGHT(A1)&" "&MID(A1,2,1)&REPT(LEFT(A1),2)&" "&MID(A1,2,1)&REPT(RIGHT(A1),2)&" "&REPT(RIGHT(A1),3)&" "&REPT(RIGHT(A1),2)&LEFT(A1)&" "&REPT(RIGHT(A1),2)&MID(A1,2,1)&" "&RIGHT(A1)&REPT(LEFT(A1),2)&" "&RIGHT(A1)&REPT(MID(A1,2,1),2)&" "&A1&" "&LEFT(A1)&RIGHT(A1)&MID(A1,2,1)&" "&RIGHT(A1)&MID(A1,2,1)&LEFT(A1)&" "&RIGHT(A1)&LEFT(A1)&MID(A1,2,1),""))) 如果需要可以下拉复制公式对A2,A3进行求值,(本公式只针对1至3位数)

热心网友时间：2024-10-17 21:46