Dim a As Double: a = 3.1314156 If a * 10 ^ 5 / 10 <> Fix(a * 10 ^ 4) Then a = (Fix(a * 10 ^ 4) + 1) / 10 ^ 4 Debug.Print a End If
If x > 3.1314 Then x = 3.1315
Else x = 3.1314
End If
val(a * 10 ^ 5 / 10)
Private Sub Command1_Click() Dim a(2) As Single, i As Integer, L As Integer a(0) = 3.1314: a(1) = 3.13141: a(2) = 3.13146 For i = 0 To 2 L = Len(CStr(a(i))) - InStr(a(i), ".") If L > 4 Then a(i) = Val(Left(a(i), Len(CStr(a(i))) - L + 4) + 0.0001) End If Debug.Print a(i) Next
End Sub
Private Sub Command1_Click() Dim a(2) As Single, i As Integer, L As Integer a(0) = 3.1314: a(1) = 3.13141: a(2) = 3.13146 For i = 0 To 2 If Len(Mid(a(i), InStr(a(i), ".") + 1)) > 4 Then a(i) = (Int(a(i) * 10 ^ 4) + 1) / 10 ^ 4 End If Debug.Print a(i) Next
If a * 10 ^ 5 / 10 <> Fix(a * 10 ^ 4) Then
a = (Fix(a * 10 ^ 4) + 1) / 10 ^ 4
Debug.Print a
End If
x = 3.1315
Else
x = 3.1314
End If
Private Sub Command1_Click()
Dim a(2) As Single, i As Integer, L As Integer
a(0) = 3.1314: a(1) = 3.13141: a(2) = 3.13146
For i = 0 To 2
L = Len(CStr(a(i))) - InStr(a(i), ".")
If L > 4 Then
a(i) = Val(Left(a(i), Len(CStr(a(i))) - L + 4) + 0.0001)
End If
Debug.Print a(i)
Next
End Sub
Private Sub Command1_Click()
Dim a(2) As Single, i As Integer, L As Integer
a(0) = 3.1314: a(1) = 3.13141: a(2) = 3.13146
For i = 0 To 2
If Len(Mid(a(i), InStr(a(i), ".") + 1)) > 4 Then
a(i) = (Int(a(i) * 10 ^ 4) + 1) / 10 ^ 4
End If
Debug.Print a(i)
Next
End Sub