總租金計算 (11523)

D2{=B$2*C2-SUM(INT(C2/A$3:A$4)*(A$3:A$4/A$2:A$3*B$2:B$3-B$3:B$4))

另解{=SUM(INT(C2/A$2:A$4)*CHOOSE({1;2;3},B$2,B$3-(A$3/A$2)*B$2,B$4-(A$4/A$3)*B$3))