View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pat Pat is offline
external usenet poster
 
Posts: 210
Default 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