Quick question, just for interest...

[Tibbs]

What's the difference between Floor and Rounddown?

Looking at the function help guide there doesn't seem to be any...

Many thanks,

Chris

[Bob Phillips]

ROUNDDOWN only rounds to a decimal place or a power of ten (down to nearest
1, 10, 100, .1,01, etc.), whereas as FLOOR sets it down to the nearest
value, which can be a decimal place or power of 10 like ROUNDOWN, or any
other value.

So

=ROUNDDOWN(223,-2)

is the same as

=FLOOR(223,100)

but there is no direct equivalent of say

=FLOOR(223,110)

You can get it with

=ROUNDDOWN(223/110,1)*110

but I know which I prefer

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tibbs" <[email protected]> wrote in
message news:[email protected]...
>
> What's the difference between Floor and Rounddown?
>
> Looking at the function help guide there doesn't seem to be any...
>
> Many thanks,
>
> Chris
>
>
> --
> Tibbs
> ------------------------------------------------------------------------
> Tibbs's Profile:
http://www.excelforum.com/member.php...o&userid=15947
> View this thread: http://www.excelforum.com/showthread...hreadid=520996
>

[Tibbs]

Thanks for that, my curiosity has been assuaged!

Chris