excel if函数问题,A1=11,A2=RIGHT(A1,1),A3-IF(A2=1,"1","0") 为什麽显示0?excel if函数问题,A1=11,A2=RIGHT(A1,1),A3=IF(A2=1,"1","0")为什麽显示0?
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/06 21:07:59
![excel if函数问题,A1=11,A2=RIGHT(A1,1),A3-IF(A2=1,](/uploads/image/z/2552820-60-0.jpg?t=excel+if%E5%87%BD%E6%95%B0%E9%97%AE%E9%A2%98%2CA1%3D11%2CA2%3DRIGHT%28A1%2C1%29%2CA3-IF%28A2%3D1%2C%221%22%2C%220%22%29+%E4%B8%BA%E4%BB%80%E9%BA%BD%E6%98%BE%E7%A4%BA0%3Fexcel+if%E5%87%BD%E6%95%B0%E9%97%AE%E9%A2%98%2CA1%3D11%2CA2%3DRIGHT%28A1%2C1%29%2CA3%3DIF%28A2%3D1%2C%221%22%2C%220%22%29%E4%B8%BA%E4%BB%80%E9%BA%BD%E6%98%BE%E7%A4%BA0%3F)
excel if函数问题,A1=11,A2=RIGHT(A1,1),A3-IF(A2=1,"1","0") 为什麽显示0?excel if函数问题,A1=11,A2=RIGHT(A1,1),A3=IF(A2=1,"1","0")为什麽显示0?
excel if函数问题,A1=11,A2=RIGHT(A1,1),A3-IF(A2=1,"1","0") 为什麽显示0?
excel if函数问题,
A1=11,A2=RIGHT(A1,1),A3=IF(A2=1,"1","0")
为什麽显示0?
excel if函数问题,A1=11,A2=RIGHT(A1,1),A3-IF(A2=1,"1","0") 为什麽显示0?excel if函数问题,A1=11,A2=RIGHT(A1,1),A3=IF(A2=1,"1","0")为什麽显示0?
A1=11,则A2=1(A2的公式是显示A1值最右边的第一个字符),即right显示的是文本格式,不是数字
A3=0,是指当A2=1为真时,显示为1,而实际上A2显示的是文本,不等于1,所以显示的是0.
若要等于1,将公式改为:A2=value(right(A1,1)
期望得到你的认可
注意RIGHT函数返回的是个字符,A2的值是个字符,不是数值,你将A3修改成下面的就可以了
A1=11,A2=RIGHT(A1,1),A3=IF(A2="1","1","0")
A3=IF(A2=1,"1","0")
改为:
=IF(A2=“1”,"1","0")
因为A2=RIGHT(A1,1)得到的是1,但是是文本格式,你可以加一个函数VALUE(A2)=1就可以了 ,因为文本的1和数值型的1,是不相等的,即A2<>1,所以,根据条件公式显示为0