Thread
:
divide and round up
View Single Post
#
6
Posted to microsoft.public.excel.misc
colglbo
external usenet poster
Posts: 4
divide and round up
On Thu, 05 Jan 2017 14:54:02 -0500, colglbo
wrote:
On Thu, 5 Jan 2017 10:12:30 -0800 (PST),
wrote:
On Monday, September 21, 2009 at 12:40:02 PM UTC-5, 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.
What if I want to divide cell D5 by cell B4 and then roundup?
=INT(C5/4)+1
Didn't read question correctly
=INT(D5/B4)+1
Reply With Quote
colglbo
View Public Profile
Find all posts by colglbo