问题描述:
请Excel高手解说下列公式每个函数项结果是什么
=IF(SUM($E$9:$E$31)=0,"",IF((SUM($G$9:$G$31)/SUM($E$9:$E$31))>1,E5,SUM($G$9:$G$31)/SUM($E$9:$E$31)*E5))
=IF(SUM($E$9:$E$31)=0,"",IF((SUM($G$9:$G$31)/SUM($E$9:$E$31))>1,E5,SUM($G$9:$G$31)/SUM($E$9:$E$31)*E5))
问题解答:
我来补答展开全文阅读