Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
automatically round down or up
Not possible without using the functions in formulas or having event code to do
the job. What would the requirements be for rounding up or down? Gord Dibben MS Excel MVP On Fri, 30 Nov 2007 02:53:01 -0800, DonnaO wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically round small calculated values to zero | Excel Discussion (Misc queries) | |||
Round up down or anywhere | Excel Discussion (Misc queries) | |||
Round up to 100? | Excel Worksheet Functions | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
In Excel, how do you get it to not automatically round my dollars. | Excel Worksheet Functions |