Roundup, Roundown to a specific digit or number

  • Thread starter Thread starter Guest
  • Start date Start date
G

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"
 
=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
 
Good catch, so much for a quick response before walking out the door :-(

Jerry
 
Back
Top