麻烦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)

来源：学生作业帮助网 编辑：作业帮 时间：2024/05/04 20:21:22
麻烦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)
麻烦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（）是对这个区域求和.

其他的IF（）,是判断相关值后,得到结果.

麻烦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(C2 excel中,函数=if(if-0.03 EXCEL中=IF(H11 EXCEL问题 =IF(C2=,,RAND()), EXCEL表格公式=IF(J10 excel 中公式含义=IF(O4 excel表格中=IF(I5-H5 在EXCEL中=IF(MONTH(F3) Excel函数,=if(row(N2-1) excel表格中公式=IF(Y3 excel中函数=IF(I5 EXCEL条件 =IF(H4>F4,H4-F4,IF(H4 为什么Excel显示是FALSE..=IF(M5,IF(N5 EXCEL中函数IF(C10=,,IF(C100, 关于Excel常识 =IF(OR(F2=,G2=),,F2*G2)=IF(OR(F2=,G2=),,F2*G2) 刚用Excel不怎么清楚 这个=IF OR 还有中间用两个逗号隔开的“” 代表什么?麻烦详细说说. EXCEL里面 =IF(V16=O13*0.85,X,O) =IF(A2=,B1,A2)这个EXCEL函数是什么意思