精準計算 區間值細分 (13344)

I3{=IFERROR((OFFSET(A$2,,MATCH(1=1,A3:E3<=F3,)-1)+(F3-OFFSET(A3,,MATCH(1=1,A3:E3<=F3,)-1))/SUM(OFFSET(A3,,MATCH(1=1,A3:E3<=F3,)-2,,2)*{1,-1})*SUM(OFFSET(A$2,,MATCH(1=1,A3:E3<=F3,)-2,,2)*{1,-1})),1)*G3