Keith Lumley

Posts: n/a

round up a 1999 + 1999 to the nerest 100 = 2000 + 2000

i want to round up a cell that has a fomular in it B1+B2 b1 is 1999 and b2 is
1999 the answer is 3998 but i want 4000
Thanks Keith

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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	2	May 13th 23 11:46 AM

All times are GMT +1. The time now is 12:01 PM.

About Us

"It's about Microsoft Excel"