| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding formulas for negative numbers
Bob Phillips wrote:
To quote help FLOOR Regardless of the sign of number, a value is rounded down when adjusted away from zero. If number is an exact multiple of significance, no rounding occurs Obvious typo in the Excel Help page: is rounded down when adjusted __toward__ zero. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| save .xls w/o the formulas just the numbers | New Users to Excel | |||
| How do I delete formulas but save numbers? | Excel Worksheet Functions | |||
| Can rounded numbers be summed without rounding errors? | Excel Discussion (Misc queries) | |||
| My formulas can't 'see' numbers imported from Access in Excel, even when the format is the same. | Excel Discussion (Misc queries) | |||
| How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
Hybrid Mode
