Thread: formula help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default formula help
Try

=CEILING(A1,3)

Mike

"Silverline" wrote:

what formula is used when you enter a number into cell and it is round up to
a multiple of 3. So if 20 is entered in a cell that it is changes it to 21.
--
glen
Reply With QuoteReply With Quote