SUMPRODUCT(FREQUENCY(ROW(INDIRECT("1:"&YEARFRAC(A2,B2)*12)),ROW($1:$8)*36)*(1+(ROW($1:$9)-1)*E2)*D2/12)
另解=SUMPRODUCT(D2/12*(1+E2*INT((ROW(OFFSET(Z$1,,,DATEDIF(A2,B2,"m")+1))-1)/36)))
複利=SUMPRODUCT(D2/12*(1+E2)^INT((ROW(OFFSET(Z$1,,,DATEDIF(A2,B2,"m")+1))-1)/36))
留言
張貼留言