Is there a function that allows roundup, for example if the price is 5.23 it will round UP to 5.30?

thanks

I think this will probably work - I haven't tested it yet though

For your problem, you would enter RoundUp(5.23, 1)

Public Function RoundUp(number As Double, significant As Integer) As Double
    RoundUp = Round(number, significant)
    If RoundUp < number Then
        RoundUp = RoundUp + (1 / (10 * significant))
    End If
End Function

You could then format the result using Format(5.3, "0.00")

Hope that helps,

Mike

Mike
EchoVue.com

it seems to work thanx

now I will like the RoundUp function to ignore Null values

thanks

You could try adding...

If Not IsnNull(number) then
  <Function Code>
Else
   RoundUp = 0 'Or whatever value you would like
End if
End Function

Mike
EchoVue.com