Roundup, Roundown to a specific digit or number

[Guest]

Is there any way to use the "Round, Roundup or Rounddown" function to round results to a specific number?

In my case I'm trying to roundup the sum's result to the nearest "9"

 

[Jerry W. Lewis]

=ROUND(x*9,0)/9
or
=MROUND(x,9)

MROUND requires the Analysis ToolPak, which is on the Excel CD, but may
not have been installed.

Jerry

 

[ElsiePOA]

I believe in Jerry's reply the first formula should have been

=ROUND(x/9,0)*

 

[Jerry W. Lewis]

Good catch, so much for a quick response before walking out the door :-(

Jerry