How to round down

[TaGY2K]

How do you round down from excel ..

ie. 14.56 to 14
14.4 to 14
14.8 to 14

 

[Roger Govier]

Try
=ROUNDDOWN(A1,0)

 

[KL]

=ROUNDDOWN(14.56,0)
=INT(14.56)
=FLOOR(14.56,1)

Regards,
KL

 

[Don Guillett]

Look in HELP index for ROUND

 

[comish4lif]

=rounddown(14.56,0) where the ",0" rounds down to 0 decimal places.

You can also wrap this function around another calculation:
=rounddown(a1/b1,0)

 

[Ron Coderre]

Try this:

=ROUNDDOWN(A1,0)
(Rounds towards zero)

14.7>>>14
-1.8>>>-1


Does that help?

Ro