1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62
| Private Sub Calucler_Click()
Dim m As Single
Dim z As Single
Dim t As Single
Dim a As Single
Dim b As Single
Dim v As Single
Dim H As Single
Dim E As Single
Dim F As Single
Dim L As Single
Dim D As Single
Dim K As Single
Dim Q As Single
Dim C As Single
If montantprêt.Text = "" Then
montantprêt.Text = 0
End If
m = montantprêt
If nbmensualité.Text = "" Then
nbmensualité.Text = 0
End If
z = nbmensualité
If Val(taux.Text) <> 0 Then
taux.Text = Replace(taux.Text, ".", ",")
t = (taux / 100)
a = m * t / 12
b = 1 - (1 + t / 12) ^ (-z)
v = Round(a / b, 2)
If Val(assu1.Text) <> 0 Then
assu1.Text = Replace(assu1.Text, ".", ",")
H = (assu1 / 100)
E = (m * H) / 12
F = (E * z)
End If
L = assuf
D = fraisdossier
mensualité2 = v
K = Round((v) + (L) + (E), 2)
Q = Round(((K * (z)) + (D) + (F)) - (m), 2)
C = Round((m) + (Q), 2)
mensualitéassu = K
couttotal = FormatNumber(Q, 2, True)
total = FormatNumber(C, 2, True)
End If
End Sub |
Partager