更新时间2018-03-06 18:31:25
这个公式计算出来的结果为负数,我想让这负数显示为“0”,公式要怎么加进去,意思就是只要是负数就显示为0,如果是正数就正常显示。谢谢
=IF(J5=H5,"20",IF(J5>H5,20+(J5-H5)*0.5,IF(J5<H5,20-(H5-J5)*0.5)))
=IF(IF(J5=H5,20,IF(J5>H5,20+(J5-H5)*0.5,IF(J5<H5,20-(H5-J5)*0.5)))<0,0,
IF(J5=H5,20,IF(J5>H5,20+(J5-H5)*0.5,IF(J5<H5,20-(H5-J5)*0.5))))
=IF(J5=H5,"20",IF(20+ABS(J5-H5)*0.5<0,0,IF(J5>H5,20+(J5-H5)*0.5,IF(J5<H5,20-(H5-J5)*0.5))))
上一篇:flash版本过低怎么升级
下一篇:为什么QQ语音的时候听不到消息