Computer Aided Automation
Round UP Function in Excel VBA - Printable Version

+- Computer Aided Automation (https://www.computeraidedautomation.com)
+-- Forum: VBA Programming (https://www.computeraidedautomation.com/forumdisplay.php?fid=1)
+--- Forum: Excel VBA (https://www.computeraidedautomation.com/forumdisplay.php?fid=3)
+--- Thread: Round UP Function in Excel VBA (/showthread.php?tid=4)



Round UP Function in Excel VBA - CAA - 08-01-2019

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)