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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Round up/down duration 0
Round up or down to nearest 5, but not 10 2
Divide a # into 3 #'s rounded to a whole # 9
Round up or down by set variable 3
Rounding Up question 2
rounding a number up to a certain ending digit 6
Round Function 5

Top