How to creat a custom roundup function in Access

[nagiese]

I need to create a custom roundup function that works exactly the same as the built-in ROUNUP function in Excel (ex. 98.37 rounds up to 99.00% in excel). I tried the following code but it always rounds up to 100%

Public Function roundup(number) As Long    If Int(number) < number Then
         roundup = Int(number) + 1
    Else
         roundup = number
    End If
End Function

How do I write this so a number like 98.37 or 98.01 rounds up to 99%, but I can't have any number over 100%.

Thanks so much for your help.
Nena

[CJ_London]

you need to be clear what your numbers and format are - you talk about 98.37 and 98.01 but then mention 99%/100%. to be 99% the number must be .9837 in which case the formula would be

(int(number*100)+1)/100

[isladogs]

Here's a variation using the Fix function (which always rounds down)

Function RoundUp(Number) As Long

If CInt(Number) = Number Then
    RoundUp = Number
Else
    RoundUp = Fix(Number) + 1
End If


End Function

NOte this assumes you are working with numbers like 98.37 not calculated % based on e.g. 98.37/100 - same point as ajax made really