excel有两列,第一列有数字我想第二列数字大于10的显示A,大于5小于10的显示B,小于五的显示C,如何操作？

Question

如题所述

Answer 1

=IF(A1>10,"A",IF(A1>5,"B","C"))
或
=IF(A1<5,"C",IF(A1<10,"B","A"))
或
=IF(A1="","",LOOKUP(A1,{-9E+307,5,10}+10^-8,{"C","B","A"}))
下拉填充

Answer 2

=if(a2<5,"C",if(a2>10,"A","B"))
下拉

Answer 3

输入公式“=IF(A1>10,"A",IF(AND(A1>5,A1<10),"B",IF(A1<5,"C","")))"

Answer 4

假设数据在A列，b1输入：=if(a1<5,"C",if(a1<10,"B","A"))

Answer 5

IF(A1>=10,"a",IF(A1>5,"b",IF(A1<5,"c")))
用这个试试