software

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

Excel already rounds up at 0.5

Under what circumstances are you experiencing different rounding behavior?

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

XL2002, WinXP-Proquot;Gregquot; wrote:

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

That's what it does

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Nothwest Excel Solutions
www.nwexcelsolutions.com
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Gregquot; gt; wrote in message
...
gt; Is it possible to alter the rounding rules in Excel so that it rounds up
gt; when
gt; the value is .5 or higher
Try these tips usinf custom functions

vertex42.com/ExcelTips/significant-figures.html

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