rounding numbers in a calculation

  • Thread starter Thread starter KimberlyC
  • Start date Start date
K

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!
 
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
 
Back
Top