【EXCEL IF函数】的问题,还望高手来帮忙阿~~~~~~~~~~~

2024-12-14 16:33:47
推荐回答(4个)
回答1:

=IF(A1>=0,IF(A1<=3,"小",IF(A1<=6,"中",IF(A1<=9,"大","特大"))),"不能小于0")

回答2:

=IF(AND(A1>=0,A1<=3),"小",IF(AND(A1>=4,A1<=6),"中",IF(AND(A1>=7,A1<=9),"大","")))

回答3:

=if(x<0,"",if(x<=3,"小",if(x<=6,"中",if(x<=9,"大",""))))

回答4:

B1
=if(a1<=3,"小",if(a1<=6,"中",if(a1,<=9,"大","太大")))