Posted to microsoft.public.excel.worksheet.functions

David Biddulph[_2_] David Biddulph[_2_] is offline

external usenet poster

Posts: 8,651

Rounding Question

=ROUND(A2/1000,0) ?
--
David Biddulph

"Art" wrote in message
...
Is it possible to create a rounding formula for the following?

270,400 = 270
270,600 = 271

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
Rounding Question	Curt J	Excel Worksheet Functions	9	November 20th 08 09:46 PM
rounding question	Jean K	Excel Discussion (Misc queries)	2	May 22nd 08 08:34 PM
Rounding Question	John	Excel Discussion (Misc queries)	2	December 18th 06 08:29 PM
Rounding Question		Excel Discussion (Misc queries)	4	February 3rd 06 01:42 PM
Rounding Question	PastorHankWi	Excel Worksheet Functions	3	March 31st 05 01:09 AM

All times are GMT +1. The time now is 06:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us