塑石假山施工工艺流程:excel 公式
来源:百度文库 编辑:神马品牌网 时间:2024/05/22 22:55:49
B列是A列的70%
公式
如果A列无数据B列也不显示0
公式
如果A列无数据B列也不显示0
=IF(a1>0,a1*0.7,IF(a1="","",IF(a1<0,"亏本啦")))
=if(A1=" "," ",A1*0.7)
=IF(a1>0,a1*0.7,IF(a1="","",IF(a1<0,"亏本啦")))
=if(A1=" "," ",A1*0.7)