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

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