Thread: round a formula's result
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBeaucaire[_31_] JBeaucaire[_31_] is offline
external usenet poster
  
Posts: 1
Default round a formula's result

=CEILING(A1,100)

...will cause the number in A1 to always roundUP to the nearest 100.
Useful function to have in your arsenal.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45612

Reply With QuoteReply With Quote