Excel - How to round up to the nearest five

How can I make a 34 to a 35 etc etc.

How can i round up any number to the nearest five or ten?

E.G a 39 to a 40, a 6 to a 10 and a 1132 to a 1135.

thanks.

  Mike H replied to James

Hi,

Try this

=CEILING(A1,5)
Mike

  Jacob Skaria replied to James

When you say nearest..39 should be 40 and 36 should be 35 right?

=ROUND(A1/5,0)*5

If this post helps click Yes
---------------
Jacob Skaria

  JLatham replied to Jacob Skaria

I agree that he confused the issue with his statement:
which would imply that 6 should be rounded DOWN to 5,  but the example data
showed "a 6 to a 10 and 1132 to 1135" so it does look like always round up.

Thanks in advance Excel Discussions Excel 2003 (1) Excel (1) TRUE returns (1) Decimal (1) ROUND (1) CELL (1) SUM (1) SUM function (1) Mondou has brought this to us : I SUM(A1:C1) (returns: 649.88516; displays: 649.89) modified to. . . A1: 570.45 B1: = ROUND(A1*5%, 2) (returns 28.52) C1: = ROUND((A1+B1)*8.5%, 2) (returns 50.91) D1: = SUM(A1:C1) (returns 649.88 5%) ld Works Great ! . . . Thanks Garry. You'd think think that EXCEL would incorporate this round function in the Currency Format. As for the Double Taxing, I agree with you, it taxing ! Ironically, apparently you want just the opposite: you want to ensure that Excel does round results. When you display to 2 decimal places, Excel rounds the displayed value. For example 28.53 - - again, the displayed number. There are two ways to make that happen: * Explicitly round expressions that you intend to be accurate to the displayed precision. * Set the "Precision as one of the reasons not use PAD. I think it would be better to explicitly round expressions. Even though that can seem tedious, it gives you the flexibility of not rounding the operands are. For example, 10.1-10-0.1 is not exactly zero. But ROUND(10.1-10-0.1, 2) is. After serious thinking Mondou wrote : Well, I happen

approfondire: https: / / sites.google.com / site / e90e50 / documento-plinius / quizzone-di-excel - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Stavolta parleremo del. . . round's mystery! :-) Non sono particolarmente pigro, ma odio lavorare inutilmente e, secondo me, coloro che il furbo e ho inserito una UDF molto sbrigativa, questa: - -- -- -- -- -- -- -- -- -- - Function ROT(n, d) ROT = Round(n, d) End Function - -- -- -- -- -- -- -- -- -- - Certo, sapevo bene che non era esattamente equivalente ad ARROTONDA, che più che bene. Certo, avrei potuto impostarla diversamente: - -- -- -- -- -- -- -- -- -- - Function ROT(n, d) ROT = Application.WorksheetFunction.Round(n, d) End Function - -- -- -- -- -- -- -- -- -- - ma era troppo lungo da scrivere e poi, sbagliando, ero convinto identici a quelli di ARROTONDA (senza, ovviamente, usare la funzione del foglio). La prima usando "ROUND" ed apportandovi le opportune rettifiche nei casi in cui il risultato diverga da quello di "ARROTONDA". La seconda usando altre funzioni VBA, diverse da ROUND. Le due funzioni saranno ritenute corrette solo in quanto io non riesca a trovare alcun poi sono anche quelli di ARROTONDA). Buon divertimento! E. :-) Excel - Italian Discussions ROT Application.WorksheetFunction.Round n (1) WorksheetFunction (1) Excel (1) Function ROT n (1) ROT Round n (1) Decimal (1) ROUND (1) Udf (1) http: / / support.microsoft.com / kb / 225330 / it :-) saluti r in particolare l

in Advance!!! Excel Discussions Advance Hi Bob Am Fri (1) Office 2003 (1) Vista (1) CEILING (1) ROUND (1) XP (1) Office 2003 SP2 (1) Le (1) Hi Bob, Am Fri, 22 Jul also shown as .04 If you want .0322 to come out .03 you should try: = ROUND(C34 / A34, 2) Regards Claus Busch - - Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 / 2007 Ultimate SP2 hi, = CEILING(C34 / A34, 0.01) - - isabelle Le 2011-07-22 15:42, Bob a ?crit : Thanks