rounding down
 

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.

rounding down
 

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

--
Message posted from http://www.ExcelForum.com

rounding down
 

use the =ROUNDDOWN(,0)

"JT" wrote:

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.