ceiling & floor

Is there a difference between
=CEILING(cellreference,1)
and
=ROUNDUP(cellreference,0)

(The same goes for FLOOR / DOWN of course.)

Thanks.

Bill Ridgeway
Computer Solutions

Hi Bill

For this specific case - don't think so. You can use:

=CEILING(cellreference,1)
=ROUNDUP(cellreference,0)

=FLOOR(cellreference,1)
=ROUNDDOWN(cellreference,0)
=INT(cellreference)
=TRUNC(cellreference,0)

but in other situations the functions can do things differently.

Regards,
KL




"Bill Ridgeway" <info@1001solutions.co.uk> wrote in message
news:dd50fj$str$1@newsg1.svr.pol.co.uk...
> Is there a difference between
> =CEILING(cellreference,1)
> and
> =ROUNDUP(cellreference,0)
>
> (The same goes for FLOOR / DOWN of course.)
>
> Thanks.
>
> Bill Ridgeway
> Computer Solutions
>
>