Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a function to round down in Excel?
If I use Round(A1,0), if the value of A1 is 0.6, Round(A1,0) will be
1. However, I want to round DOWN to 0 for 0.6. In other words, I only want to keep the integer part of the number. Even if it's 1.9, after rounding, I want it to be 1 instead of 2. Any suggestion? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a function to round down in Excel?
I want to round DOWN to 0
I assume that means there will not be any negative numbers. Try this: =INT(A1) -- Biff Microsoft Excel MVP "Curious" wrote in message ... If I use Round(A1,0), if the value of A1 is 0.6, Round(A1,0) will be 1. However, I want to round DOWN to 0 for 0.6. In other words, I only want to keep the integer part of the number. Even if it's 1.9, after rounding, I want it to be 1 instead of 2. Any suggestion? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a function to round down in Excel?
Hi,
One way =INT(A1) Mike "Curious" wrote: If I use Round(A1,0), if the value of A1 is 0.6, Round(A1,0) will be 1. However, I want to round DOWN to 0 for 0.6. In other words, I only want to keep the integer part of the number. Even if it's 1.9, after rounding, I want it to be 1 instead of 2. Any suggestion? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a function to round down in Excel?
While ROUNDDOWN (and ROUNDUP) do exist, what you're asking for is just the
integer, so you can use =INT(A1) If you *really* wanted ROUNDDOWN =ROUNDDOWN(A1,0) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Curious" wrote: If I use Round(A1,0), if the value of A1 is 0.6, Round(A1,0) will be 1. However, I want to round DOWN to 0 for 0.6. In other words, I only want to keep the integer part of the number. Even if it's 1.9, after rounding, I want it to be 1 instead of 2. Any suggestion? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a function to round down in Excel?
Functions which you may wish to look at in Excel help include:
ROUNDDOWN INT TRUNC FLOOR The "See Also" entry in Excel help for a given function will often tell you about similar or related functions. -- David Biddulph "Curious" wrote in message ... If I use Round(A1,0), if the value of A1 is 0.6, Round(A1,0) will be 1. However, I want to round DOWN to 0 for 0.6. In other words, I only want to keep the integer part of the number. Even if it's 1.9, after rounding, I want it to be 1 instead of 2. Any suggestion? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a function to round down in Excel?
Hi,
besides the INT and ROUNDOWN functions you could use: =TRUNC(A1,0) =FLOOR(A1,1) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Curious" wrote: If I use Round(A1,0), if the value of A1 is 0.6, Round(A1,0) will be 1. However, I want to round DOWN to 0 for 0.6. In other words, I only want to keep the integer part of the number. Even if it's 1.9, after rounding, I want it to be 1 instead of 2. Any suggestion? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a function to round down in Excel?
Many thanks to all of you! This is helpful.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round up function | Excel Discussion (Misc queries) | |||
how do i set up round function | Excel Worksheet Functions | |||
The ROUND function | Excel Worksheet Functions | |||
round function in excel 2000 | Excel Worksheet Functions | |||
Round Function | Excel Discussion (Misc queries) |