多个IF函数公式怎么连在一起,在同一个单元格中得出数值。具体如下...答:试试这个=if(C9<=0.59),"甲",IF(C9<=0.65),"乙",IF(C9<0.77),"丙",IF(C9<=0.90),"丁",IF(C9<1),"戊",IF(C9<=1.13),"红",IF(C9<=1.32),"橙",IF(C9<=1.5),"黄",IF(C9<=1.85),"绿",IF(
excel表格一个怎么输入多几个IF?答:意思是:A1单元格的值如果大于5,则返回"大",否则返回"小"二、两层的IF函数公式的格式 =IF(条件一,条件成立时的值,IF(条件二,条件二成立时的值,两个条件都不成立时的值))如在B1单元格写入公式 =IF(A1="男","60岁退休",IF(A1="女","55岁退休",""))意思是:如果A1单元格的值是"男",...
如何合并这三个if函数到一个单元格里面?答:直接改,用IF嵌套函数,最后为什么要显示为文本0呢,不显示为空?=IF(OR(ISNUMBER(FIND({"四川","陕西","北京","天津","山西","重庆","海南","云南","甘肃","宁夏","内蒙古","贵州","山东","河北"},C2))),"二区",IF(OR(ISNUMBER(FIND({"江苏","浙江",...
请问,EXCEL里面,同一个单元格可以有几种情况的IF函数吗?答:可以的 假定单元格1为A2,单元格2为B2 b2输入 =IF(A2>=5000,"",IF(A2>4000,400,IF(A2>3000,300,IF(A2>2000,200,"")))公式里,假定a1<=2000和a1>=5000,都为空值