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