divide and round up
On Thursday, January 5, 2017 at 12:30:41 PM UTC-8, 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.
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.
|