Thread: Sum + Round Up
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Canon Canon is offline
external usenet poster
 
Posts: 55
Default Sum + Round Up

Excel 2007
Using the following formula, =sum(A4*$B$3), I would like the amount to
always round up to the next 5
ie: if the true answer is $45.12, I would like the cell to show $45.15