rounding numbers in a calculation

[KimberlyC]

Hi

I have a cell that contains a calculation that adds up some numbers in a
column. I need this number to round down instead of up ( no decimal places
show).
Is it possible to format that cell to round down?
If yes, how???


Thanks in advance for you help

Kimberly!

 

[Frank Kabel]

Hi
one way:
=INT(your_formula)

or
=ROUNDDOWN(your_formula,0)

or
=TRUNC(your_formula,0)

Note: TRUNC and INT will differ for negative values. e.g.
TRUNC(-4.3) = -4
INT(-4.3) = -5