excel2016函数,希望高手给个回答,谢谢!

2024-12-28 07:52:58
推荐回答(2个)
回答1:

公式:

=MID(SUBSTITUTE(B1,"+",""),2,99)-MID(SUBSTITUTE(A1,"+",""),2,99)

回答2:

=RIGHT(B1,3)-RIGHT(A1,3)+(MID(B1,2,LEN(B1)-5)-MID(A1,2,LEN(A1)-5))*1000