Question

怎么简化excel中的运算公式？

=(F12-(N12-F12*12.68%/12))-(N12-(F12-(N12-F12*12.68%/12))*12.68%/12)，这个公式是重复使用的，怎么简化公式

Answer 1

多项式化简呀~
(F12-(N12-F12*12.68%/12))-(N12-(F12-(N12-F12*12.68%/12))*12.68%/12)
=(F12-N12+F12*12.68%/12) - (N12-(F12-(N12-F12*12.68%/12))*12.68%/12)
=(F12-N12+F12*12.68%/12) - (N12-(F12*12.68%/12-(N12-F12*12.68%/12)*12.68%/12))
=(1+12.68%/12)*F12-N12 - (N12-(F12*12.68%/12-(N12*12.68%/12-F12*12.68%/12*12.68%/12)))
=(1+12.68%/12)*F12-N12 - (N12-(F12*12.68%/12-N12*12.68%/12+F12*12.68%/12*12.68%/12))
=(1+12.68%/12)*F12-N12 - (N12-F12*12.68%/12+N12*12.68%/12+F12*12.68%/12*12.68%/12)
=(1+12.68%/12)*F12-N12 - N12+F12*12.68%/12-N12*12.68%/12-F12*12.68%/12*12.68%/12
=(1+12.68%/12)*F12 - 2*N12 + 12.68%/12*F12-12.68%/12*N12-12.68%/12*12.68%/12*F12
=(1+12.68%/12+12.68%/12-12.68%/12*12.68%/12)*F12 - (2+12.68%/12)*N12
=(1+2*12.68%/12-12.68%/12*12.68%/12)*F12 - (2+12.68%/12)*N12
=(1+(2-12.68%/12)*12.68%/12)*F12 - (2+12.68%/12)*N12
这已经够简单了吧

Answer 2

SUMIF函数只支持单列 需要两列相加,可以用公式 =SUMIF(bom!$A:$A,$B157,bom!$D:$D)+SUMIF(bom!$A:$A,$B157,bom!$E:$E)..