LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 12
Default automatically round down or up

Is it possible to change settings on Excel 2003 so that the answer to
calculations are automatically rounded up or down, according to requirements.
An example of this would be 12.12 * 12.12 being rounded up to 146.90 or down
to 146.89, without using the roundup or round down functions
 
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
Automatically round small calculated values to zero Keypoker2 Excel Discussion (Misc queries) 1 November 30th 07 04:21 AM
Round up down or anywhere Joel Excel Discussion (Misc queries) 0 February 15th 07 02:55 PM
Round up to 100? Fred Holmes Excel Worksheet Functions 1 February 21st 05 02:40 PM
How do I ROUND() round off decimals of a column dataset? Højrup Excel Worksheet Functions 2 January 12th 05 10:50 AM
In Excel, how do you get it to not automatically round my dollars. Cylie G. Excel Worksheet Functions 2 January 7th 05 10:43 PM


All times are GMT +1. The time now is 07:26 PM.

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

About Us

"It's about Microsoft Excel"