View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default formula for a pension

"Peo Sjoblom" wrote:
I meant with regards, to the post saying "Well, for truncating"
it is incorrect, INT rounds down to the nearest integer,
TRUNC truncates


Technically correct. My comment was made in context.
The discussion is about compensation etc, which is always
positive. The OP said that INT() would "round". I said it
"truncates". Arguably, I should have said "rounds down".
I was tempted to write that, but I thought "truncate" might
be clearer, since it is the same thing for positive numbers.

Having said all that, I will try to be more careful in the future,
since "int" does mean truncate (the unsigned magnitude)
in some programming languages.