excel中如果的函数
我在单元格中输入这个公式,其中D134=2172518400,为什么得数不正确,谢谢网友指导。=IF(600000<D134<=10000000,1.3*POWER(10000000/D134,0.0738),IF(10000000<D134<=1000000000,POWER(1000000000/D134,0.057),IF(1000000000<D134<=10000000000,POWER(1000000000/D134,0.0706),1.6)))
公式修改如下就可以了:
=IF(AND(600000<D134,D134<=10000000),1.3*POWER(10000000/D134,0.0738),IF(AND(10000000<D134,D134<=1000000000),POWER(1000000000/D134,0.057),IF(AND(1000000000<D134,D134<=10000000000),POWER(1000000000/D134,0.0706),1.6)))
600000<D134<=10000000这样是数学上的表示方法,在excel中要用and函数,即:
and(D134>600000,D134<=10000000)
热门标签: