ceiling & floor

  • Thread starter Thread starter Bill Ridgeway
  • Start date Start date
B

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
 
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
 
Back
Top