View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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?