Thread
:
Sum + Round Up
View Single Post
#
1
Posted to microsoft.public.excel.misc
Canon
external usenet poster
Posts: 55
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
Reply With Quote
Canon
View Public Profile
Find all posts by Canon