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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding formulas for negative numbers
Pat wrote: 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 Hi Patrizia, Take for your "ARROTONDA.ECCESSO": =-ARROTONDA.DIFETTO(-A1;0,5) And for your "ARROTONDA.DIFETTO": =-ARROTONDA.ECCESSO(-A1;0,5) if your numbers are negative and write 4,2 into cell A1. Regards, Bernd |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding formulas for negative numbers
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 CEILING Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an exact multiple of significance, no rounding occurs -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Pat" wrote in message ... 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 |
#4
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) |