| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ROUND UP or DOWN by 0.5
Can someone help please?
Is it possible to round up or down to the nearest 0.5 For example 6.2 would round to 6 and 6.3 would round to 6.5. Thanks in advance. -- Regards Warren |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ROUND UP or DOWN by 0.5
=ROUND(A20*2,0)/2
-- __________________________________ HTH Bob "Warren Easton" wrote in message ... Can someone help please? Is it possible to round up or down to the nearest 0.5 For example 6.2 would round to 6 and 6.3 would round to 6.5. Thanks in advance. -- Regards Warren |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ROUND UP or DOWN by 0.5
Perfect, Thank You.--
Regards Warren "Bob Phillips" wrote: =ROUND(A20*2,0)/2 -- __________________________________ HTH Bob "Warren Easton" wrote in message ... Can someone help please? Is it possible to round up or down to the nearest 0.5 For example 6.2 would round to 6 and 6.3 would round to 6.5. Thanks in advance. -- Regards Warren |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ROUND UP or DOWN by 0.5
=MROUND(A2,0.5)
Look up MROUND in Excel help if you have problems. -- David Biddulph "Warren Easton" wrote in message ... Can someone help please? Is it possible to round up or down to the nearest 0.5 For example 6.2 would round to 6 and 6.3 would round to 6.5. Thanks in advance. -- Regards Warren |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round to .99? | Excel Worksheet Functions | |||
| round up | Excel Worksheet Functions | |||
| Round hh:mm:ss to whole hh:mm | Excel Worksheet Functions | |||
| VBA round | Excel Discussion (Misc queries) | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Hybrid Mode
