drop the decimal without rounding
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!].
--
David Biddulph
"annc5411" wrote in message
...
I need to drop the decimals without rounding, so if the answer is 23.65 it
would be 23
|