| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
| Rounding | Excel Discussion (Misc queries) | |||
| Percentage rounding error in charts | Excel Discussion (Misc queries) | |||
| Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
| How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
Linear Mode
