View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default ROUNDUP vs CEILING

ROUNDUP only uses significant digits.
=ROUNDUP(4.231,2) would be 4.24
whereas CEILING allows rounding up to a nearest multiple
=CEILING(4.231,0.05) would be 4.25
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Rebecca_SUNY" wrote:

Could someone explain the difference between ROUNDUP and CEILING?