The INT function others have suggested will work fine as long as your
numbers are all positive values. However, if you can have negative value,
then you should use this instead...
Either =INT(A1) or =TRUNC(A1), depending on how you want to treat negative
numbers.
=ROUNDDOWN(A1,0) is another option, and for positive numbers also
=FLOOR(A1,1) [or to allow for -ve numbers too, =FLOOR(A1,SIGN(A1)) but that
might be overdoing the complication!].
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
