Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop the decimal without rounding
I need to drop the decimals without rounding, so if the answer is 23.65 it
would be 23 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop the decimal without rounding
A1 = 23.65
=INT(A1) -- Biff Microsoft Excel MVP "annc5411" wrote in message ... I need to drop the decimals without rounding, so if the answer is 23.65 it would be 23 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop the decimal without rounding
=INT(A1)
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "annc5411" wrote: I need to drop the decimals without rounding, so if the answer is 23.65 it would be 23 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop the decimal without rounding
Use INT()
=INT(A1) If this post helps click Yes --------------- Jacob Skaria "annc5411" wrote: I need to drop the decimals without rounding, so if the answer is 23.65 it would be 23 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop the decimal without rounding
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) -- Rick (MVP - Excel) "annc5411" wrote in message ... I need to drop the decimals without rounding, so if the answer is 23.65 it would be 23 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal Rounding | Excel Discussion (Misc queries) | |||
Rounding up for a decimal | Excel Worksheet Functions | |||
Rounding to two even decimal places | Excel Worksheet Functions | |||
Decimal Place Rounding | Excel Worksheet Functions | |||
Rounding decimal | Excel Worksheet Functions |