|
實數顯示的數字(excel只顯示前15位數)不見的是全部數字
決解方式上面老師已經說明過
下列程式利用不同精度定義的變數(Long、Single、Double)做比較,有不同比較結果
Sub abcd()
Dim La As Long, Lb As Long 'E+18
Dim Da As Double, Db As Double 'E+308
Dim Sa As Single, Sb As Single 'E+38
Dim xR As Range
Set xR = [D1]
If [A1] = [B1] Then xR = "相同" Else xR = "不同"
xR(1, 2) = "[A1]=[B1]"
La = [A1]: Lb = [B1]: Set xR = xR.Offset(1)
If La = Lb Then xR = "相同" Else xR = "不同"
xR(1, 2) = "Long,E+18"
Sa = [A1]: Sb = [B1]: Set xR = xR.Offset(1)
If La = Lb Then xR = "相同" Else xR = "不同"
xR(1, 2) = "Single,E+38"
Da = [A1]: Db = [B1]: Set xR = xR.Offset(1)
If Da = Db Then xR = "相同" Else xR = "不同"
xR(1, 2) = "Double,E+308"
A = [A1]: B = [B1]: Set xR = xR.Offset(1)
If A = B Then xR = "相同" Else xR = "不同"
xR(1, 2) = "Variant"
End Sub
|
|