Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding in Excel
Want to know if this is even possible. I need excel to round numbers down
that are .50 and lower and up for numbers that are .51 and higher. Excel tends to round up when numbers are .50 and higher. So for instance 10.51 and higher would need to round up to 11 whereas 10.50 and lower would round down 10. I am very unfamiliar with formulas so if you can explain to me what to do step by step I would appreciate it. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel won't stop rounding numbers. Please help | Excel Discussion (Misc queries) | |||
Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
How do I stop excel from rounding numbers? | Excel Discussion (Misc queries) | |||
How do I record (.468) time in Excel without it rounding to .5? | Excel Discussion (Misc queries) |