Question

Excel提示你为此函数输入太多参数的问题，if函数怎么用

现有A单元格，B单元格，C单元格
当A<C*60%,B=0
C* 80%>A>=C*60%,B=4%
C* 100%>A>=C*80%,B=6%
C* 150%>A>=C*100%,B=8%
A>C*150%,B=12%
IF(H6<G6*60%,J6="按第十条计算",IF(AND(G6*80%>H6>=G6*60%),J6=4%,IF(AND(G6*100%>H6>=G6*80%),J6=6%,IF(AND(G6*150%>H6>=G6*100%),J6=8%,IF(H6>G6*150%,J6=12%)))))，H6不管是什么值,J6返回的都是0.0%。囧！

Answer 1

if只是在判断一个条件是否成立时使用，多个条件就要使用很多if嵌套。
if(A<C*60%,B=0,if(and(C*80%>A,A>=C*60%),B=4%,if(and(C*100%>A,A>=C*80%),B=6%,if(and(C*150%>A,A>=C*100%),B=8%,if(A>C*150%,B12%)))))
AND的语法是AND(XXX , XXXX)

追问

不懂！！！！

追答

=+IF(AND(G6*80%,H6>=G6*60%),4%,IF(AND(G6*100%,H6>=G6*80%),6%,IF(AND(G6*150%,H6>=G6*100%),8%,IF(H6>G6*150%,12%))))

Answer 2

=if(A>C*1.5,0.12,if(A>C,0.08,if(A>C*0.8,0.06,if(A>C*0.6,0.04,""))))