How can I alter the rounding rules?
 

Is it possible to alter the rounding rules in Excel so that it rounds up when
the value is .5 or higher

How can I alter the rounding rules?
 

Excel already rounds up at 0.5

Under what circumstances are you experiencing different rounding behavior?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Greg" wrote:

Is it possible to alter the rounding rules in Excel so that it rounds up when
the value is .5 or higher

How can I alter the rounding rules?
 

That's what it does

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Nothwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Greg" wrote in message
...
Is it possible to alter the rounding rules in Excel so that it rounds up
when
the value is .5 or higher

How can I alter the rounding rules?
 

Try these tips usinf custom functions

http://vertex42.com/ExcelTips/significant-figures.html

"Greg" Is it possible to alter the rounding rules in Excel so that it
rounds up when
the value is .5 or higher