公式为：
=IF(AND(A1>=22,A1<=40),"新锐版","新秀版")
如图所示:
设年龄数据 在B3单元格 ，这公式为：=IF(OR(B3<22,B3>40),"新秀版","新锐版")
=IF(A1>=22,IF(A1<=40,"新锐版","新秀版"),"新秀版")
假设年龄在列A中=if(and(a1>21,a1<39),"新锐版","新秀版")或者=if(or(a1<22,a1>40),"新秀版","新锐版")
