Rounding
 

In Excel how do I round a number up to end in .9?

Excel 2002 SP1

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

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

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