给个邮箱吧，请教个excel函数问题，谢谢

先在H1中定义函数如下：=IF(AND(A1<5%),0,IF(AND(A1>=5%,A1<10%,B1>=30000),B1*0.5%,IF(A1<15%,B1*1%,IF(A1<20%,B1*2%,IF(A1<30%,B1*2.5%,IF(A1>=30%,B1*3%))))))    

 定义好之后按回车；

然后单击选中H1，把鼠标移动到该单元格的右下角，如图所示；

向下拖动至依情况而定即可。

=IF(A1<0.05,0,IF(AND(A1>=0.05,A1<0.1,B1>=30000),B1*0.005,IF(AND(A1>=0.1,A1<0.15),B1*0.01,IF(AND(A1>=0.15,A1<0.2),B1*0.02,IF(AND(A1>=0.2,A1<0.3),B1*0.025,IF(A1>=0.3,B1*0.03,0))))))

用IF() 在H1中输入
=IF(A<5%,0,IF(AND(A<10%,A>=5%,B1>=30000),B1*0.5%,IF(AND(A<15%,A>=10%),B1*1%,IF(AND(A<20,A>=15%),B1*2%,IF(AND(A<30%,A>=20%),B1*2.5%,B1*3%)))))

假定A在A1格，在H1格输入公式：
=IF(A1<5%,0,IF(AND(AND(A1>=5%,A1<10%),B1>=30000),B1*0.5%,IF(AND(A1>=10%,A1<15%),B1*1%,IF(AND(A1>=15%,A1<20%),B1*2%,IF(AND(A1>=20%,A1<30%),B1*2.5%,IF(A1>=30%,B1*3%,B1))))))

H1的公式
=IF(A1<5%,0,IF(AND(A1<10%,B1>=30000),0.5%,IF(A1<15%,1%,IF(A1<20%,2%,IF(A1<30%,2.5%,3%)))))*B1