excel if函数嵌套问题.见鬼了,=IF(A1>=90,"35%",IF(90>A1>=40,"25%",IF(40>A1>=10,"15%",IF(10>A1>=0,"5%",0))))想表达的是,如果A1大于90,返回35%,A1在40与90之间,返回25%,A1在10与40之间,返回15%,A1在0到10之间,返回5%.可是
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/01 04:21:00
![excel if函数嵌套问题.见鬼了,=IF(A1>=90,](/uploads/image/z/1348365-21-5.jpg?t=excel+if%E5%87%BD%E6%95%B0%E5%B5%8C%E5%A5%97%E9%97%AE%E9%A2%98.%E8%A7%81%E9%AC%BC%E4%BA%86%2C%3DIF%28A1%3E%3D90%2C%2235%25%22%2CIF%2890%3EA1%3E%3D40%2C%2225%25%22%2CIF%2840%3EA1%3E%3D10%2C%2215%25%22%2CIF%2810%3EA1%3E%3D0%2C%225%25%22%2C0%29%29%29%29%E6%83%B3%E8%A1%A8%E8%BE%BE%E7%9A%84%E6%98%AF%2C%E5%A6%82%E6%9E%9CA1%E5%A4%A7%E4%BA%8E90%2C%E8%BF%94%E5%9B%9E35%25%2CA1%E5%9C%A840%E4%B8%8E90%E4%B9%8B%E9%97%B4%2C%E8%BF%94%E5%9B%9E25%25%2CA1%E5%9C%A810%E4%B8%8E40%E4%B9%8B%E9%97%B4%2C%E8%BF%94%E5%9B%9E15%25%2CA1%E5%9C%A80%E5%88%B010%E4%B9%8B%E9%97%B4%2C%E8%BF%94%E5%9B%9E5%25.%E5%8F%AF%E6%98%AF)
excel if函数嵌套问题.见鬼了,=IF(A1>=90,"35%",IF(90>A1>=40,"25%",IF(40>A1>=10,"15%",IF(10>A1>=0,"5%",0))))想表达的是,如果A1大于90,返回35%,A1在40与90之间,返回25%,A1在10与40之间,返回15%,A1在0到10之间,返回5%.可是
excel if函数嵌套问题.见鬼了,
=IF(A1>=90,"35%",IF(90>A1>=40,"25%",IF(40>A1>=10,"15%",IF(10>A1>=0,"5%",0))))
想表达的是,如果A1大于90,返回35%,A1在40与90之间,返回25%,A1在10与40之间,返回15%,A1在0到10之间,返回5%.可是这个公式只能返回35%和25%两个值.
比如A1如果是4,应该返回5%,但是返回的是25% ,
excel if函数嵌套问题.见鬼了,=IF(A1>=90,"35%",IF(90>A1>=40,"25%",IF(40>A1>=10,"15%",IF(10>A1>=0,"5%",0))))想表达的是,如果A1大于90,返回35%,A1在40与90之间,返回25%,A1在10与40之间,返回15%,A1在0到10之间,返回5%.可是
“90>A1>=40”这种表达式,EXCEL无法正确改读,正确表达式为:AND(90>A1,A1>=40)
公式可写成:
=IF(A1>=90,"35%",IF(A1>=40,"25%",IF(A1>=10,"15%",IF(A1>=0,"5%",0))))
也可写成:
=IF(A1>=90,0.35,IF(A1>=40,0.25,IF(A1>=10,0.15,IF(A1>=0,0.05,0))))
后者需将单元格格式设为百分比.