| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i round to the nearest 0.5 in excel
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i round to the nearest 0.5 in excel
One way:
=ROUND(A1*2,0)/2 bigred wrote: -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| How do I tell a price list to round up and down to the nearest 25 | Excel Worksheet Functions | |||
| Formula to enter to round an Excel value up to the next $0.5? | Excel Discussion (Misc queries) | |||
| Round Up to Nearest 10 | Excel Worksheet Functions | |||
| In Excel, how do you get it to not automatically round my dollars. | Excel Worksheet Functions | |||
Linear Mode
