Rounding Up To 3 or 4 decimals

C

ChrisR

I have a calculated field for cost that could have as many as 10 decimal
places in the results. I want to come up with a few functions so that I can
round up to 2, 3, or 4 decimals based on the value. For instance, if price
is > $1, round up to 2 decimals, but if price between .50 and 1.0, round up
to 3 decimals. This part would be handled by a simple IIF statement. Any
help with building 3 separate functions...

RoundUp2
RoundUp3
RoundUp4

Thanks in advance for any help.

c-
 
Top