培训师简历模板:excel 公式
来源:百度文库 编辑:高考问答 时间:2024/05/23 15:14:27
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)