ceiling & floor

[Bill Ridgeway]

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

 

[KL]

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