Round down numbers
 

I am trying to round down a number to the next whole number. Example 9.2
would round down to 9, 6.0 would round down to 5.0

Round down numbers
 

Dale wrote:
I am trying to round down a number to the next whole number. Example 9.2
would round down to 9, 6.0 would round down to 5.0

Round down numbers
 

Hi,

You can use =ROUND(A1,0) to round off to the whole number. But then even
that wont round off 6.0 to 5.0. Is that what you really want?

Govind.

Dale wrote:

I am trying to round down a number to the next whole number. Example 9.2
would round down to 9, 6.0 would round down to 5.0

Round down numbers
 

Are you looking at only positive numbers?

You could use

=INT(A1)

but this would make 6 remain 6, if you really want to do what you say
then

=CEILING(A1-1,1)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=503149

Round down numbers
 

How about this:

=ROUNDDOWN(A1-.001,0)

HTH,
Elkar


"Dale" wrote:

I am trying to round down a number to the next whole number. Example 9.2
would round down to 9, 6.0 would round down to 5.0