看来搂主并不想四舍五入就想取整数,并且想在原先的整数位加一
因为搂主的其中一个例子是:如a=1.1,变成2
看看这个怎么样
Public Function Int2(Data As String) As Long
Dim X() As String, XLen As Long
X = Split(Data, ".")
On Error GoTo OneLen
XLen = UBound(X)
If Int(X(XLen)) <> 0 Then
Int2 = Int(X(LBound(X))) + 1
Else
Int2 = Int(X(LBound(X)))
End If
Exit Function
OneLen:
Int2 = Int(X(LBound(X)))
End Function
Function allin(i As Single)
Dim a As Single
a = -i
allin = -Int(a)
End Function
Private Sub Command1_Click()
Dim a As Single
a = Trim(Text1.Text)
Print Round(allin(a))
End Sub
原理把数先变成负数,再取整,然后再变回来就成了