Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there any way to round to the nearest 1/8, 1/4, etc in Excel.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there any way to round to the nearest 1/8, 1/4, etc in Excel.
Hi Lisa,
Use the MROUND() function. If you get a #NAME error: ToolsAdd-ins, check Analysis Toolpak -- Kind regards, Niek Otten Microsoft MVP - Excel "Lisa" wrote in message ... | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there any way to round to the nearest 1/8, 1/4, etc in Excel.
"Lisa" wrote in message
... Yes. You multiply by 8, 4, etc., then round normally (to nearest integer), then divide by 8, 4, etc. So, for example, =ROUND(8*A1,0)/8 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there any way to round to the nearest 1/8, 1/4, etc in Excel.
Firstly, try asking the question in the body of the message rather than just
in the subject line. Secondly, have you looked at Format/ Cells/ Fractions? [But that would just change the display, so if you wanted to change the value you'd need the "Precision as Display" option, which is dangerous if you forget that you've applied it.] A better option would be =MROUND(A1,0.125) or =MROUND(A1,0.25) [and you could couple that with formatting as a fraction if you want it displayed that way]. -- David Biddulph "Lisa" wrote in message ... |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there any way to round to the nearest 1/8, 1/4, etc in Excel.
See
http://www.xldynamic.com/source/xld.Rounding.html Rounding In Excel - Techniques -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Lisa" wrote in message ... |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there any way to round to the nearest 1/8, 1/4, etc in Excel.
On Tue, 13 Nov 2007 07:42:05 -0800, Lisa
wrote: =ROUND(A1*8,0)/8 and format the cell as fraction with up to one digit --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i round in excel to the nearest thousand | Excel Worksheet Functions | |||
how do i round to the nearest 0.5 in excel | Excel Discussion (Misc queries) | |||
How do I round down to nearest .05% in Excel? | Excel Discussion (Misc queries) | |||
How do I round to the nearest $5.00 in Excel? $74.03=$75 | Excel Worksheet Functions | |||
How can I round a number to the nearest "50" or "100" in excel 200 | Excel Worksheet Functions |