excel中不同条件适用不同公式
发布网友
共5个回答
热心网友
假如A列为原数据
B1中输入公式 =IF(AND(A1>=1,A1<=5),A1*0.2,IF(AND(A1>=6,A1<=10),A1*0.15,"设定条件范围外"))
然后向下复制公式
热心网友
=IF(AND(A1>=1,A1<=5),A1*0.2,IF(AND(A1>=6,A1<=10),A1*0.15,""))
在2003中,依此可镶套7层
=IF(A1>10,"",IF(A1>=6,A1*0.15,IF(A1>=1,A1*0.2,"")))
热心网友
假如A列为原数据
B1中输入公式 =IF(OR(A1>=1,A1<=5),A1*0.2,IF(OR(A1>=6,A1<=10),A1*0.15,""))
然后向下复制公式
热心网友
=IF(D3>=0,IF(D3>=5,IF(D3>=10,D3*0.3),D3*0.2),D3*0.1)
热心网友
都很对！
