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.
|