Excel多重条件取值问题！！！急！

来源：百度知道 编辑：UC知道 时间：2024/06/02 20:40:46
分几个数值段，假设A1为数值单元格，B1为取值显示格，
A1取值范围界定为5个，A1大于等于1.2 0.9(含）-1.2 0.8（含）-0.9 0.7（含）-0.8 0.7以下
根据以上5段取值，B1分别显示 A B C D E
例A1＝0.9 则B1显示“B” A1＝0.8 则B1显示“C”以此类推。
以上情况如何设置公式？请教各位高手！
另：如何在公式中表示大于等于？小于等于？

=IF(A1<=1.2,"A",IF(AND(A1>=0.9,A1<1.2),"B",IF(AND(A1>=0.8,A1<0.9),"C",IF(AND(A1>=0.7,A1<1.8),"D","E"))))

B1:
=IF(A1="","",LOOKUP(A1,{0,0.7,0.8,0.9,1.2},{"E","D","C","B","A"}))

一楼和二楼的公式是错的，应该是：
=IF(A15>=1.2,"A",(IF(A15>=0.9,"B",(IF(A15>=0.8,"C",(IF(A15>=0.7,"D","E")))))))

B1单元格输入：

=IF(A1>=1.2,"B",IF(A1>=0.9,"C",IF(A1>=0.8,"D",IF(A1>=0.7,"E","F"))))

向下拖动复制该公式

如果只有5个（不多于7个）可以简单的用IF嵌套来解决。
=IF(A1>=1.2,"A",IF(A1>=0.9,"B",IF(A1>=0.8,"C",IF(A1>=0.7,"D","E"))))
这是偷懒做法，哈哈！