| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
correct to the nearest half
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
correct to the nearest half
It wouild have been better if you had explained more fully what it is that
you want to do in the body of the post, but taking a guess try: =ROUND(A1*2,0)/2 -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "soorya" wrote in message ... |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
correct to the nearest half
Hi soorya,
You can also use =MROUND(A1,0.5) You will need to have the Analysis Tool Pack installed in order to use MROUND. See the help file for details on how to do this. HTH Martin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split by half month | Excel Discussion (Misc queries) | |||
| Split by half month | Excel Discussion (Misc queries) | |||
| Excel. How to round a number to nearest half number? | Excel Discussion (Misc queries) | |||
| how do i round time to the nearest half a minute | Excel Discussion (Misc queries) | |||
| Countif that can i half | Excel Discussion (Misc queries) | |||
Linear Mode
