automatically round down or up

D

DonnaO

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
 
G

Gord Dibben

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
 
Top