vba round number
Function RoundTo(pNumber As Long, pFactor As Long)
RoundTo = Round(pNumber / pFactor) * pFactor
End Function
' ---------------------------------------------------------------
Sub TestMe()
Debug.Print RoundTo(2543, 10) ' => 2540
Debug.Print RoundTo(2546, 10) ' => 2550
Debug.Print Application.RoundUp(10.1, 0) ' => 10
Debug.Print Application.RoundUp(10.6, 0) ' => 11
Debug.Print Application.RoundDown(10.6, 0) ' => 10
End Subvba round to 2 decimals
Debug.Print Round(10.3456, 2) ' 10.35 Double
Debug.Print Format(10.3456, "0.00") ' 10.35 String (Variant)Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
