Sorry for not being clear enough.

I'd like to multiply the number in [G8] (for example, 11.27) times [H8] (for
example, 71.50), and allow the user to pick an interval stored in [C4] (for
example, 0.25] and round the answer to that -- either the nearest, or forcing
it up or down. There would be many such computations -- we're preparing
price sheets.

So -- result of multiplication is 11.27 x 71.5 = 80.57

I'd like to allow the user to round the result to:

forcing it up (like the Excel RoundUp function) -- 80.75
forcing it down (like the RoundDown function) -- 80.50
nearest (like the MRound function) -- 80.50

Thanks in advance.

"Jerry W. Lewis" wrote:

An example would greatly clarify what you mean by rounding "to an interval"

Jerry

"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.