Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Round UP Function in Excel VBA
#1
Example round up function for excel vba

Function RoundUp(ByVal Value As Double)
    If Int(Value) = Value Then
        RoundUp = Value
    Else
        RoundUp = Int(Value) + 1
    End If
End Function


'call statements
sideholes = RoundUp(VARIABLE)
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)