How to round to fractions in Excel 2003
Thread poster: Samuel Murray

Samuel Murray  Identity Verified
Netherlands
Local time: 06:54
Member (2006)
English to Afrikaans
+ ...
Oct 1, 2013

Hello everyone

I want Excel 2003 to round down hours to the nearest 0.5. What formula do I need for that?

In other words:
* if the cell's value is 1.8, I want to round it to 2.0.
* if the cell's value is 1.7, I want to round it to 1.5.
* if the cell's value is 1.6, I want to round it to 1.5.
* if the cell's value is 1.4, I want to round it to 1.5.
* if the cell's value is 1.3, I want to round it to 1.5.
* if the cell's value is 1.2, I want to round it to 1.0.
* if the cell's value is 1.1, I want to round it to 1.0.

Thanks!
Samuel


Direct link Reply with quote
 

Marie-Helene Dubois  Identity Verified
Spain
Local time: 06:54
Member (2011)
Spanish to English
+ ...
MRound function Oct 1, 2013

Hi Samuel,

You need the MROUND function for that.
You need the original figure in one cell and the new (rounded up or down) figure in another cell for this to work.

Here is a really good and clear tutorial that shows you the formula to use:

http://spreadsheets.about.com/od/excelfunctions/qt/90212mround.htm

You would just use MROUND([cell number with original value],[rounding value, in your case 0.5]). You can then just drag this formula down to apply it to all cells.


Direct link Reply with quote
 

Marie-Helene Dubois  Identity Verified
Spain
Local time: 06:54
Member (2011)
Spanish to English
+ ...
here's how it looks on my Excel Oct 1, 2013

=MROUND(A1;0,5)

as an example. I'm using 2007 and the non-English number format though so you may need to adjust accordingly.

Oh and I forgot to say, make sure you format the results column to show at least one decimal place or Excel will round up/down even further.

[Edited at 2013-10-01 14:17 GMT]


Direct link Reply with quote
 

Attila Piróth  Identity Verified
France
Local time: 06:54
Member
English to Hungarian
+ ...
Another simple option Oct 1, 2013

Multiply by 2, round it to the nearest integer, divide by 2.

Best,
Attila


Direct link Reply with quote
 

Kirsten Bodart  Identity Verified
United Kingdom
Local time: 06:54
Dutch to English
+ ...
Help function Oct 1, 2013

I think you should also be able to find it in the integrated help function, but About.com is also good.

Direct link Reply with quote
 

Samuel Murray  Identity Verified
Netherlands
Local time: 06:54
Member (2006)
English to Afrikaans
+ ...
TOPIC STARTER
Thanks everyone Oct 1, 2013

Samuel Murray wrote:
I want Excel 2003 to round down hours to the nearest 0.5. What formula do I need for that?


Thanks, everyone, for your answers. I did read the help files and suchlike, but I could not figure out which of the many examples applied to my specific situation.


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

How to round to fractions in Excel 2003

Advanced search






memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search