View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
colglbo colglbo is offline
external usenet poster
 
Posts: 4
Default 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