Thread: Help with formula to round up to next higher multiple of 5
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default Help with formula to round up to next higher multiple of 5
Try this:

=CEILING(A1,5)

--
Biff
Microsoft Excel MVP


"LarryUSCGMWR" wrote in message
...
Hi,

I am looking for a quick formula that can take a number and round it up to
the next higher integer that is a multiple of 5. Does anyone have a
formula
for this. You can email me at with any suggestions.

Thanks



Reply With QuoteReply With Quote