Question

EXCEL单元格A1输入3-6,A2的值会=A1最后值6减最前值3再加1的公式如何写

Answer 1

不管横杠（“-”）前面或者后面有多少数字，都不受影响计算结果，看了楼下的回答，如果前面和后面超出2位数字，那计算就错误了

A2=MID(A1,FIND("-",A1)+1,LEN(A1)-FIND("-",A1))-MID(A1,1,FIND("-",A1)-1)+1

Answer 2

给你一个更人性化的
=IF(A1="","",IF(A1="-",1,IF(ISERROR(VALUE(SUBSTITUTE(A1,"-",""))),"非法字符",IF(LEN(A1)-LEN(SUBSTITUTE(A1,"-",""))<>1,"格式错误",IF(REPLACE(A1,1,FIND("-",A1),"")="",,REPLACE(A1,1,FIND("-",A1),""))-IF(REPLACE(A1,FIND("-",A1),LEN(A1)-FIND("-",A1)+1,"")="",,REPLACE(A1,FIND("-",A1),LEN(A1)-FIND("-",A1)+1,""))+1))))

Answer 3

=6-3+1
=4

Answer 4

A2=RIGHT(A1,1)-LEFT(A1,1)+1