Round down numbers

[Guest]

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

 

[Govind]

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

 

[Govind]

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.

 

[daddylonglegs]

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)

 

[Guest]

How about this:

=ROUNDDOWN(A1-.001,0)

HTH,
Elkar