|
楼主 |
发表于 2024-7-30 23:14
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
由indirect("R1C1:R2C3",0)为引用的为A1:C2区域,可推出INDIRECT("R2C2:R2C"&COLUMN(),0),INDIRECT("R3C2:R3C"&COLUMN(),0),将INDIRECT("R2C2:R2C"&COLUMN(),0)+INDIRECT("R3C2:R3C"&COLUMN(),0)代入到下列公式中
(C8-LOOKUP(1,0/(B2:N2+B3:N3),B2:N2+B3:N3))/LOOKUP(1,0/(B2:N2+B3:N3),B2:N2+B3:N3)得出:
(C8-LOOKUP(1,0/(INDIRECT("R2C2:R2C"&COLUMN(),0)+INDIRECT("R3C2:R3C"&COLUMN(),0)),INDIRECT("R2C2:R2C"&COLUMN(),0)+INDIRECT("R3C2:R3C"&COLUMN(),0)))/LOOKUP(1,0/(INDIRECT("R2C2:R2C"&COLUMN(),0)+INDIRECT("R3C2:R3C"&COLUMN(),0)),INDIRECT("R2C2:R2C"&COLUMN(),0)+INDIRECT("R3C2:R3C"&COLUMN(),0))为什么会算出不结果呢? |
|