| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rounding
num = rnd()*10
newnum = int(num) & .9 otherwise, define what your rules are. -- Regards, Tom Ogilvy "Aaron King" wrote: In Excel how do I round a number up to end in .9? Excel 2002 SP1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| Rounding | Excel Worksheet Functions | |||
| Worksheet rounding vs VBA rounding | Excel Programming | |||
| Rounding | Excel Discussion (Misc queries) | |||
Threaded Mode
