excel如何根据某一列数值的范围，自动填充内容

B1单元格写入公式 =IF(A1<1,"",IF(A1<11,"AA",IF(A1<21,"BB",""))) 或 =IF(A1="","",LOOKUP(A1,{0,"";1,"AA";11,"BB";21,""}))