EXCEL水电费函数计算
发布网友
共3个回答
热心网友
1在G44中输入=IF((E3-D3)<C3,"0",IF(AND((E3-D3)<>0,C3=0),"空房用电",E3-D3-C3))
2在F49中输入=IF(OR(D49="未抄表",E49="未抄表",D49="",E49=""),"缺少数据",IF(E49<D49,"数据异常"，IF（F49/C49>3,"用电过多"，E49-D49)))
热心网友
F4
=IF(OR(D4="",E4="",D4="未抄表",E4="未抄表"),"缺少数据",IF(D4>E4,"数据异常",IF(INT((E4-D4)/C4)>3,"用电过多",E4-D4)))
G4
=IF(F4>0,IF(C4=0,"空房用电",IF(C4>F4,0,F4-C4)),0)
一起下拉
热心网友
G44输入=IF(F44<c44,0,if(and(c44=0,f44<>0),"空房用电",F44-C44))
F49输入=IF(OR(D49="未抄表",E49="未抄表",D49="",E49=""),"缺少数据",IF(E49<D49,"数据异常",IF(E49-D49>C49*3,"用电过多",E49-D49)))
