Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mike
 
Posts: n/a
Default 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   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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   Report Post  
Sandy Mann
 
Posts: n/a
Default

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   Report Post  
mike
 
Posts: n/a
Default

Thank you both for the help.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Graphing Trouble ¤Xperimental¤ Excel Discussion (Misc queries) 1 February 3rd 05 02:18 PM
roundup seconds to minute obi-akpere Excel Worksheet Functions 1 January 7th 05 01:50 PM
Trouble with Averaging across several worksheets Fysh Excel Worksheet Functions 7 December 2nd 04 03:36 AM
Roundup K.S.Warrier Excel Worksheet Functions 0 November 24th 04 11:05 AM
Maps.........Having Trouble Loading things grasshopper Excel Worksheet Functions 1 November 3rd 04 04:29 PM


All times are GMT +1. The time now is 10:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"