求问excel公式：数值在90-100之间，显示a，在80-90之间，显示b，在70-80之间，显示c

Question

如题所述

Answer 1

if(X>=90，"a",if(X>=80，"b",if(X>=70，"c","")))

Answer 2

比如A1是数值，另一单元格公式 =IF( OR(A1<70,A1>100),"超过范围",CHOOSE((A1-60)/10,"a","b","c"))本回答被网友采纳

Answer 3

=if(and(a1>=70,a1<80),"c",if(and(a1>=80,a1<90),"b",if(and(a1>=90,a1<100),"a","数据溢出")))本回答被提问者采纳