Excel中，当A列的值满足一个条件或B列满足一个条件时返回函数怎么设计

Question

Excel中，当A列的值满足一个条件或B列满足一个条件时返回函数怎么设计公式，如图

Answer 1

C1输入公式：
=IF(OR(A1<=10000,B1<=1000),"a",IF(OR(A1<=100000,B1<=10000),"b",IF(OR(A1<=200000,B1<=30000),"c",IF(OR(A1<=50000000,B1<=1000000),"d","e"))))
下拉填充。本回答被网友采纳

Answer 2

用iF函数=if（A1<10000...）