View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default 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.