| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you round to 0.5 in excel
In some instances I need to round the results of calculations to the nearest
0.5 before continuing to the next stage |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do you round to 0.5 in excel
=ROUND(D2*2,0)/2
-- Regards, Tom Ogilvy "cathypault" wrote in message ... In some instances I need to round the results of calculations to the nearest 0.5 before continuing to the next stage |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do you round to 0.5 in excel
On Wed, 22 Sep 2004 16:29:05 -0700, "cathypault"
wrote: In some instances I need to round the results of calculations to the nearest 0.5 before continuing to the next stage With the Analysis Tool Pak installed: =MROUND(A1, 0.5) Without the ATP installed: =ROUND(A1/0.5,0)*0.5 --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round Up and Round Down Time | Excel Worksheet Functions | |||
| Excel Round | Excel Worksheet Functions | |||
| How can I round to a 0 or 0.5 in Excel? | Excel Worksheet Functions | |||
| IN EXCEL, ROUND 10.45 T0 10.5 OR 10.27 TO 10.25 | Excel Discussion (Misc queries) | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Linear Mode
