| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding formulas for negative numbers
I'm trying to round a negative number with the functions floor and ceiling
but I don't get the expected value. In italian version for floor() and ceiling(): ARROTONDA.DIFETTO(-4,2;-0,5) gets -4 ARROTONDA.ECCESSO(-4,2;-0,5) gets -4,5 instead of -4,5 and -4. Can someone help me? Thanks in advance Patrizia |
| 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) | |||
Threaded Mode
