automatically round down or up

  • Thread starter Thread starter DonnaO
  • Start date Start date
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
 
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
 
Back
Top