How do I round up to the nearest 10?

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

Guest

Can anyone show me a formula to take any value in a cell and round it up to the nearest user defined 10, 20, 50, etc.?
 
To round to the nearest 10, you can use this
=round(b4,-1
"b4" is the cell reference. You would choose would cell the number you want to round is in

tj
 
=CEILING(A1,X)

where X = the rounding criterion. For instance, to round
up to the nearest 10:

=CEILING(A1,10)

HTH
Jason
Atlanta, GA
-----Original Message-----
Can anyone show me a formula to take any value in a cell
Click to expand...
and round it up to the nearest user defined 10, 20, 50,
etc.?
 
Hi Fred
if the Analysis Toolpak is installed try
=MROUND(A1,multiple)

without the Analysis Toolpak installed try
=ROUND(A1/multiple,0)*multiple

Frank
 
I think you mean

=ROUNDUP(B4,-1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi Fred!

Try:
=CEILING(A1,B1)

Rounds a number (away from zero) to the nearest multiple of
significance.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Fred said:
Can anyone show me a formula to take any value in a cell and round
Click to expand...
it up to the nearest user defined 10, 20, 50, etc.?
 
Back
Top