excel表IF函数的运用!满足以下条件a小于等于3000时,公式aᘧ࿾百分之0.5

2025-03-02 00:55:22
推荐回答(1个)
回答1:

=if(a<=3000,a*0.005, if(a<=5000,a*0.01, if(a<=10000,a*0.015, if(a<=20000,a*0.02,"") ) ) )