rounding down

J

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.
 
C

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
 
Top