Private Sub Command1_Click()
Dim k As Double
Dim n As Double
k = 1.9
n = 1
MsgBox (k - n)
End Sub结果是.9Private Sub Command1_Click()
Dim k As Double
Dim n As Double
k = 19.9
n = 19
MsgBox (k - n)
End Sub
结果是0.899999999怎么处理比较好?
Dim k As Double
Dim n As Double
k = 1.9
n = 1
MsgBox (k - n)
End Sub结果是.9Private Sub Command1_Click()
Dim k As Double
Dim n As Double
k = 19.9
n = 19
MsgBox (k - n)
End Sub
结果是0.899999999怎么处理比较好?
Dim k As Currency
Dim n As Currencyk = 19.9
n = 19
MsgBox (k - n)
End Sub
MsgBox Round(k - n, 2)
Private Sub Command1_Click()
Dim k As Double
Dim n As Double
k = 19.9
n = 19
Debug.Print CDec(k) - n '强制转换一个数就可以了
Debug.Print CCur(k) - n
Debug.Print CDec(k) - CDec(n)
Debug.Print CCur(k) - CCur(n)End Sub
和
MsgBox Round(k-n,2)
都可以