麻烦EXCEL,=IF((DE372-(CA372-CQ372))>=0,AF372,IF((DE372-(SUM(OFFSET(CB372,$V$2+1))-SUM(OFFSET(CR372,$V$2))))>=0,AF372,IF(AND((SUM(OFFSET(CB372,$V$2+1))-SUM(OFFSET(CR372,$V$2))-DE372)>0,(SUM(OFFSET(CB372,$V$2+1))-SUM(OFFSET(CR372,$V$2))-DE372)
问题描述:
麻烦EXCEL,
=IF((DE372-(CA372-CQ372))>=0,AF372,IF((DE372-(SUM(OFFSET(CB372,$V$2+1))-SUM(OFFSET(CR372,$V$2))))>=0,AF372,IF(AND((SUM(OFFSET(CB372,$V$2+1))-SUM(OFFSET(CR372,$V$2))-DE372)>0,(SUM(OFFSET(CB372,$V$2+1))-SUM(OFFSET(CR372,$V$2))-DE372)
答
看来你的表,第372行很重要一行.还有$V$2是什么数据?相同的语句太多,只解释这一句吧SUM(OFFSET(CB372,$V$2+1))其中:OFFSET(CB372,$V$2+1)的意思是: 以CB372为左上角,列数为V$2+1的一个区域,前面的SUM()是对这个...