How can I alter the rounding rules?

[Guest]

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

 

[Guest]

Excel already rounds up at 0.5

Under what circumstances are you experiencing different rounding behavior?

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

XL2002, WinXP-Pro

 

[Peo Sjobom]

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

 

[Verne T]

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