Thread: Roundup
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default Roundup
One way...

=ROUND((A1 + 0.025 )/ 0.05, 0)*0.05
--
HTH...

Jim Thomlinson


"Dennis1188" wrote:

How can I round up to get these results:

13.30 13.35
13.34 13.35
13.36 13.40
13.38 13.40

Reply With QuoteReply With Quote