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

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

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

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

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