| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rounding
In Excel how do I round a number up to end in .9?
Excel 2002 SP1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Rounding
Both in a cell or in VB it's:
Round(value, 1) ....where 1 is the number of decimal places to round to. Aaron King wrote: In Excel how do I round a number up to end in .9? Excel 2002 SP1 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Rounding
On Thu, 17 Aug 2006 09:20:01 -0700, Aaron King <Aaron
wrote: In Excel how do I round a number up to end in .9? Excel 2002 SP1 Perhaps: =CEILING(A1+0.1,1)-0.1 will do what you want? --ron |
|
#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 |
| Reply |
| 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) | |||
Hybrid Mode
