View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pdberger pdberger is offline
external usenet poster
 
Posts: 258
Default Rounding formulas

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.