EXSEL 公式计算急在线等谢谢

1个回答

=IF(A1>=10000,IF(A1>15000,"值1","20%"),IF(A1>=5000,"15%","值2"))值1,值2可以不用管他,即大于15000或小于5000显示空白,即：=IF(A1>=10000,IF(A1>15000,"","20%"),IF(A1>=5000,"15%","")) 当然也可以自己设置低于5...