| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I format a cell to round a number by 50 basis points (0.5)?
I am trying to format a number cell so that the decimal value rounds up to
the next .5. Is this possible? I |
|
#2
|
|||
|
|||
|
Can I format a cell to round a number by 50 basis points (0.5)?
Hi!
You can't use formatting in that manner but you could use a function. =CEILING(A1,0.5) Or, put your current formula inside: =CEILING(SUM(A1:A10),0.5) Biff "daveb" wrote in message ... I am trying to format a number cell so that the decimal value rounds up to the next .5. Is this possible? I |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Linear Mode
