Round Function

I need to round up by 5's.  Is there already a function to do that or do I have to write my own?  Any idea how I would write my own?  Thanks.

Round only rounds up or down to the decimal space you desire which means is rounds to base 10 (1,10,100 etc). To round up by 5 you will need to use the modulus operator and create your own function

Function RoundUpBy5(intValue)
if IsNumeric(intValue) then
if intValue mod 5 > 0 then
     intValue=intValue+(5-intValue mod 5)
end if
RoundUpBy5 = intValue
else
RoundUpBy5 = "Value is not numeric"
end if
End Function

The function above should round up by 5. If you are looking to round to the nearest number divisible by five use the function below.

Function RoundNearest5(intValue)
if IsNumeric(intValue) then
if intValue mod 5 > 2 then
     intValue=intValue+(5-intValue mod 5)
else
     intValue=intValue-intValue mod 5
end if
RoundNearest5 = intValue
else
RoundNearest5 = "Value is not numeric"
end if
End Function

Mod is considered an mathematical operator (like +,-,*,/) that is why it's not found amongst the function.