Having Trouble With Roundup

Cell F21 has a value of 908140. I want to divide this number by 27.4
and round the result up to the nearest 1000. I have put in a formula in
the cell I want the answer =Roundup(($F$21/27.4),3). The result I get
is 33144. This is the result of dividing the 908140 by 27.4. No
rounding is taking place. What am I doing wrong?
Thanks for any and all help.

Your second argument has to be negative. Using 3 rounds to three places
to the right of the decimal point.

So =ROUNDUP($F$21/27.4,-3)

will round to the nearest thousand, up or down.

To round UP to the next thousand, use

=CELING($F$21/27.4,1000)




In article <[email protected]>,
"mike" <[email protected]> wrote:

> Cell F21 has a value of 908140. I want to divide this number by 27.4
> and round the result up to the nearest 1000. I have put in a formula in
> the cell I want the answer =Roundup(($F$21/27.4),3). The result I get
> is 33144. This is the result of dividing the 908140 by 27.4. No
> rounding is taking place. What am I doing wrong?
> Thanks for any and all help.

Mike, use -3 as the argument in the ROUNDUP function

=ROUNDUP($F$21/27.4,-3)

HTH

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"mike" <[email protected]> wrote in message
news:[email protected]...
> Cell F21 has a value of 908140. I want to divide this number by 27.4
> and round the result up to the nearest 1000. I have put in a formula in
> the cell I want the answer =Roundup(($F$21/27.4),3). The result I get
> is 33144. This is the result of dividing the 908140 by 27.4. No
> rounding is taking place. What am I doing wrong?
> Thanks for any and all help.
>

Thank you both for the help.