G Guest Jan 20, 2006 #1 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
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 Jan 20, 2006 #2 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 Click to expand...
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 Click to expand...
G Govind Jan 20, 2006 #3 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.
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.
D daddylonglegs Jan 20, 2006 #4 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)
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)
