How do I round up to the nearest 10?

[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.?

 

[Guest]

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

 

[Jason Morin]

=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

and round it up to the nearest user defined 10, 20, 50,
etc.?

 

[Frank Kabel]

Hi Fred
if the Analysis Toolpak is installed try
=MROUND(A1,multiple)

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

Frank

 

[Bob Phillips]

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)

 

[Norman Harker]

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.

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

 

[Guest]

No, I meant =round...but only because I misread the question. Sorry about that

tj

 

[Frank Kabel]

Hi
Forget my post, I gave you a solution for rounding and not for a
roundUP
Frank

 

[Guest]

Dear All,

Thank you for your input. Collectively, you have solved my problem.

Fred