G
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
would round down to 9, 6.0 would round down to 5.0
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Govind
Dale said: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
G
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.
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.
D
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)
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)
G
Guest
How about this:
=ROUNDDOWN(A1-.001,0)
HTH,
Elkar
=ROUNDDOWN(A1-.001,0)
HTH,
Elkar