excel中我想取几个数,10等,他的取值空间是大于1000小于1200,9等是大于1200小于1400,怎么用公式表示

2025-04-24 14:15:04
推荐回答(1个)
回答1:

=IF(AND(A1>1000,A1<=1200),"10等",IF(A1<=1400,"9等",""))