谁能帮我解释一下这个公式

偶与然

OFFSET(本年実績!$D$5,ROW(A1),MATCH(SUBSTITUTE(RIGHT($O$1,LEN($O$1)-FIND("年",$O$1)),"度",""),本年実績!$D$3:$O$3,)-1)

huamingzhe

太高深了!中间那几个函数都没见过!

wsfsy

<p>OFFSET(本年実績!$D$5,ROW(A1),MATCH(SUBSTITUTE(RIGHT($O$1,LEN($O$1)-FIND("年",$O$1)),"度",""),本年実績!$D$3:$O$3,)-1)<br/><script type="text/javascript"></script>以本年実績!$D$5为根据地，</p><p>ROW(A1),下移1行</p><p>MATCH(SUBSTITUTE(RIGHT($O$1,LEN($O$1)-FIND("年",$O$1)),"度",""),本年実績!$D$3:$O$3,)-1 列的方向移动x行</p><p>继续向内分解函数吧</p>

[此贴子已经被作者于2010-1-17 14:33:53编辑过]