How to round to fractions in Excel 2003 Thread poster: Samuel Murray
|
|---|
Samuel Murray 
Netherlands
Local time: 06:38
Member (2006)
English to Afrikaans
+ ...
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, ... See more 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 ▲ Collapse
| | | | | 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 w... See more 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. ▲ Collapse
| | | | | 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]
| | | | Attila Piróth
France
Local time: 06:38
Member
English to Hungarian
+ ...
| Another simple option | Oct 1, 2013 |
Multiply by 2, round it to the nearest integer, divide by 2.
Best,
Attila
| | |
|
|
|
Kirsten Bodart
United Kingdom
Local time: 06:38
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.
| | | | Samuel Murray
Netherlands
Local time: 06:38
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.
| | | | 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 | Anycount & Translation Office 3000 | Translation Office 3000
Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.
More info » |
| | Protemos translation business management system | Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment 
