Thread
:
divide and round up
View Single Post
#
2
Posted to microsoft.public.excel.misc
Jim Thomlinson
external usenet poster
Posts: 5,939
divide and round up
=roundup(c5/4, 0)
--
HTH...
Jim Thomlinson
"Pammy" wrote:
I have a formula: c5/4
I want a formula to divide: c5/4 then round up to a whole number. example:
if the answer is 17.3 I want the answer to be 18.
Reply With Quote
Jim Thomlinson
View Public Profile
Find all posts by Jim Thomlinson