excel中如果的函数

更新时间2019-02-17 05:17:42

我在单元格中输入这个公式，其中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)