rounding down

[JT]

I'm looking for help with a formula. I want to round down
to the nearest integer. For example, 4.1, 4.5, and 4.9
should all round down to 4. I can find how to round but
not how to round down. Thanks for the help.

 

[Cutter]

Use the INT or TRUNC formula

Both return the next lowest integer. The only difference between the
is when dealing with negative integers.

If Cell A1 has 4.5 in it put TRUNC(A1) in B1 and you'll get

 

[Guest]

use the =ROUNDDOWN(,0)