EXCEL IF多条件函数,怎么算都只得出一个值,a<75%,0 75%≤a<90%,0.5 90%≤a<110%,1 110%≤a<150%,1.5 a≥150%,2我设的公式:IF(F11
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/21 11:07:38
![EXCEL IF多条件函数,怎么算都只得出一个值,a<75%,0 75%≤a<90%,0.5 90%≤a<110%,1 110%≤a<150%,1.5 a≥150%,2我设的公式:IF(F11](/uploads/image/z/972584-8-4.jpg?t=EXCEL+IF%E5%A4%9A%E6%9D%A1%E4%BB%B6%E5%87%BD%E6%95%B0%2C%E6%80%8E%E4%B9%88%E7%AE%97%E9%83%BD%E5%8F%AA%E5%BE%97%E5%87%BA%E4%B8%80%E4%B8%AA%E5%80%BC%2Ca%EF%BC%9C75%25%2C0+75%25%E2%89%A4a%EF%BC%9C90%25%2C0.5+90%25%E2%89%A4a%EF%BC%9C110%25%2C1+110%25%E2%89%A4a%EF%BC%9C150%25%2C1.5+a%E2%89%A5150%25%2C2%E6%88%91%E8%AE%BE%E7%9A%84%E5%85%AC%E5%BC%8F%EF%BC%9AIF%28F11)
EXCEL IF多条件函数,怎么算都只得出一个值,a<75%,0 75%≤a<90%,0.5 90%≤a<110%,1 110%≤a<150%,1.5 a≥150%,2我设的公式:IF(F11
EXCEL IF多条件函数,怎么算都只得出一个值,
a<75%,0 75%≤a<90%,0.5 90%≤a<110%,1 110%≤a<150%,1.5 a≥150%,2
我设的公式:IF(F11
EXCEL IF多条件函数,怎么算都只得出一个值,a<75%,0 75%≤a<90%,0.5 90%≤a<110%,1 110%≤a<150%,1.5 a≥150%,2我设的公式:IF(F11
改成如下形式就可以了
=IF(F11