Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 .com, "mike" 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. |
#3
|
|||
|
|||
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" wrote in message oups.com... 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. |
#4
|
|||
|
|||
Thank you both for the help.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graphing Trouble | Excel Discussion (Misc queries) | |||
roundup seconds to minute | Excel Worksheet Functions | |||
Trouble with Averaging across several worksheets | Excel Worksheet Functions | |||
Roundup | Excel Worksheet Functions | |||
Maps.........Having Trouble Loading things | Excel Worksheet Functions |