Excel求余数公式
已知7621.求034589？
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE("0123456789",MID(K3,1,1),""),MID(K3,2,1),""),MID(K3,3,1),""),MID(K3,4,1),""),MID(K3,5,1),""),MID(K3,6,1),""),MID(K3,7,1),""),MID(K3,8,1),""),MID(K3,9,1),""),MID(K3,10,1),"")
| 合并 | 去重 | 余数 |
| 162727 | 7621 | 034589 |
| 161627 | 7621 | 034589 |
| 161638 | 8631 | 024579 |
| 493816 | 986431 | 0257 |
| 383849 | 9843 | 012567 |
赞 (0)