A
annc5411
I need to drop the decimals without rounding, so if the answer is 23.65 it
would be 23
would be 23
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
T. Valko
A1 = 23.65
=INT(A1)
=INT(A1)
L
Luke M
=INT(A1)
J
Jacob Skaria
Use INT()
=INT(A1)
If this post helps click Yes
=INT(A1)
If this post helps click Yes
R
Rick Rothstein
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...
=ROUNDDOWN(A1,0)
numbers are all positive values. However, if you can have negative value,
then you should use this instead...
=ROUNDDOWN(A1,0)
D
David Biddulph
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!].
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!].