Question

已知A和B,求T.将A-B=C,C÷2=D,再将D÷8=X,C÷8=Y,C÷6=Z.

Answer 1

=IF((MOD((INT((SUBSTITUTE(A1,".","")-SUBSTITUTE(B1,".",""))/2)),8))=0,8,(MOD((INT((SUBSTITUTE(A1,".","")-SUBSTITUTE(B1,".",""))/2)),8)))&IF((MOD((SUBSTITUTE(A1,".","")-SUBSTITUTE(B1,".","")),8))=0,8,(MOD((SUBSTITUTE(A1,".","")-SUBSTITUTE(B1,".","")),8)))&IF((MOD((SUBSTITUTE(A1,".","")-SUBSTITUTE(B1,".","")),6))=0,6,(MOD((SUBSTITUTE(A1,".","")-SUBSTITUTE(B1,".","")),6)))