Home 
Search 
Today's Posts 
#1




divide and round up
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. 
#2




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. 
#3




divide and round up
Hi,
=roundup(c5/4,0) "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. 
#4




divide and round up
On Monday, September 21, 2009 at 12:40:02 PM UTC5, 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? 
#5




divide and round up
On Thu, 5 Jan 2017 10:12:30 0800 (PST), wrote:
On Monday, September 21, 2009 at 12:40:02 PM UTC5, 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 
#6




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 UTC5, 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 
#7




divide and round up
On Monday, September 21, 2009 at 12:40:02 PM UTC5, 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. Very cool thanks! I also got it to work with =ROUNDUP(D5/B4,0) 
#8




divide and round up
On Thursday, January 5, 2017 at 12:30:41 PM UTC8, wrote:
On Monday, September 21, 2009 at 12:40:02 PM UTC5, 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. Very cool thanks! I also got it to work with =ROUNDUP(D5/B4,0) The ROUNDUP() approach is better. For example, if D5 and B4 happen contain the same number, the desired result is probably 1, not 2. 
#9




divide and round up
=INT(D5/B4)+1
That wouldn't work if the result of the division is a whole number it would round up when it shouldn't roundup is the one you'd want to use 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Divide and round  Excel Discussion (Misc queries)  
Format divide by 10 / single digit view: Custom? Text(Round(  Excel Discussion (Misc queries)  
Divide by Zero  Excel Worksheet Functions  
Divide one row over other row I dont wont to divide one number  Excel Discussion (Misc queries)  
How do I ROUND() round off decimals of a column dataset?  Excel Worksheet Functions 