You can use a simple formula to round to any intervaly you want. Give this a
try.

Dim x As Double

x = Round((Range("G8") * Range("H8")) / Range("C4"), 0) * Range("C4")
--
HTH...

Jim Thomlinson


"pdberger" wrote:

Good morning.

I want the workbook user to be able to round values -- either up to a
selected interval, down, or to the nearest. The only related VBA function
I'm able to find is rounding to a number of digits. For example, I want to
multiply [G8] x [H8], and round to an interval stored in [C4].

Can I accomplish this directly in a VBA statement?

Thanks in advance.