mike

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 01:18 PM
roundup seconds to minute	obi-akpere	Excel Worksheet Functions	1	January 7th 05 12:50 PM
Trouble with Averaging across several worksheets	Fysh	Excel Worksheet Functions	7	December 2nd 04 02:36 AM
Roundup	K.S.Warrier	Excel Worksheet Functions	0	November 24th 04 10:05 AM
Maps.........Having Trouble Loading things	grasshopper	Excel Worksheet Functions	1	November 3rd 04 03:29 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us