excel中用if可以将数值大于45为不合格，小于35为不合格，35-45之间合格的excel的if语句？

Question

如题所述

Answer 1

假设数据在A1，要在B1中得到是否合格，B1
=if(and(a1>=35,a1<=45),"合格","不合格")
或者
=if((a1>=35)*(a1<=45),"合格","不合格")追问

如果计算100个值得合格率呢？感谢大神

本回答被提问者采纳

Answer 2

比如数值在A1单元格
=if(a1<35,"不合格",if(a1>45,"不合格","合格"))

Answer 3

=LOOKUP(A1,{0,35,46},{"不合格","合格","不合格"})