2在F49中輸入=IF(OR(D49="未抄表",E49="未抄表",D49="",E49=""),"缺少數據",IF(E49<D49,"數據異常",IF(F49/C49>3,"用電過多",E49-D49)))