Sum = 0 rMoney = 500000000 mMoney = Array("", "60000000", "90000000", "170000000", "230000000", "205000000", "140000000", "110000000", "70000000", "-80000000") For a = 1 To UBound(mMoney) If Sum + mMoney(a) >= rMoney Then Period = Period + 1 * (rMoney - Sum) / mMoney(a) Exit For Else Sum = Sum + mMoney(a) Period = Period + 1 End If Next MsgBox "걸리는 월수는 : " & Period