Rounding DOWN numbers

  • Thread starter Thread starter Dags
  • Start date Start date
D

Dags

OK, thread title pretty much covers it. Is there any way to round
numbers DOWN? I know most people round numbers up, but this is a
strange circumstance. I need to format a number of cells to round down
to the nearest whole number regardless of the fraction amount. I know
there is a ROUNDDOWN function, but it requires a set amount to round
down (round down by .5). Is this possible? If so, how?
 
Note that if the number is negative,

=INT(-2.77)

rounds away from zero, to give -3 (which is rounding down in value)
to round down in magnitude (i.e, toward zero, symmetric with
positive numbers), use

=TRUNC(-2.77) ==> -2
 
Good follow-up info.

Biff
-----Original Message-----
Note that if the number is negative,

=INT(-2.77)

rounds away from zero, to give -3 (which is rounding down in value)
to round down in magnitude (i.e, toward zero, symmetric with
positive numbers), use

=TRUNC(-2.77) ==> -2


.
Click to expand...
 
use =trunc()

Enter the cell with the value in the brackets. This will chop the
value to the nearest whole number. If you want a value to include 1
dec place eg 63.562 then type =trunc(cell,1) etc - This will give you
the value 63.5

Hope this helps

:D
 
You can use =rounddown(cell,0) as well this will round down to whole
numbers (the "0" part of formula)

Hope this helps

Mike
 
Back
Top