[Originally posted by Chris Murphy]
How would I always round a number UP?
Printable View
[Originally posted by Chris Murphy]
How would I always round a number UP?
[Originally posted by Andrew Chin]
Function RoundUP (Number As Double) As Double
dec = Int(Number)
If dec = Number Then RoundUP = Number Else _
RoundUP = dec + 1
End Function
RoundUP (5.00) = 5.00
RoundUP (5.25) = 6.00